Oracle New Database

Oracle creates a new database, which is a table space that is created to assign a table space to a user.

1. Create TABLE Spaces :

CREATE TABLESPACE <表空间名> DATAFILE ‘C:\app\oradata\orcl\date.dbf‘ SIZE <空间>[K|M] [AUTOEXTEND [OFF|ON]];

2. Create a user :

CREATE USER <用户名> IDENTIFIED BY <密码>  DEFAULT TABLESPACE <表空间名> [TEMPORARY TABLESPACE <l临时表空间名>];

3. Assign the tablespace to the user :

ALTER USER <用户名> DEFAULT TABLESPACE <表空间名>;

4. Authorization to the user :

GRANT create session,create table,unlimited tablespace TO <用户名>;

5. User Login :

conn <用户名>/<密码>;

Oracle New Database