Volume El creates users, tablespaces, authorizations, and so on.

Volume El creates users, tablespaces, authorizations, and so on. Category: Oracle/Informix/db2 .... Read by 368 Comment (0) Favorites Report

After oracle is installed, perform the following operations:

1. First, create (new) Users:

Create User Username identified by password;

Username: username of The New User Name

Password: the password of a new user can still be used without creating a new user, for example, continue to use Scott user

2. Create a tablespace: Create tablespace tablespacename datafile 'd: \ data. dbf' size xxxm;

Tablespacename: name of the tablespace D: \ data. DBF ': The storage location of the tablespace XXX tablespace. The unit of M is MB)

3. Allocate the space to the user: Alter User Username default tablespace tablespacename;

Allocate the tablespace named tablespacename to Username

4. Authorize the user: grant create session, create table, unlimited tablespace to username;

5. log on to the user created by the landlord, and then create a table.

Conn username/password;