Oracle Database-Build library, build table space, build users

1. Select the database directory

*\product\10.1.0\oradata\ Directory (* indicates the installation directory of Oracle)

2. CREATE TABLE Space

Format: Create tablespace table name datafile ' data file name ' size table space;

sql> Create tablespace database name datafile ' F:\oracle\product\10.1.0\oradata\news\database.dbf ' size 500M ;

3. Create user

Format: Create user username identified by password default Tablespace table space table;

sql> Create user identified by password default tablespace table space ;

4. User authorization

Sql> Grant Connect,resource to users ; --Means to grant Connect,resource permissions to news users

Sql> Grant DBA to News; --Means granting DBA authority to news users

Oracle Database-Build library, build table space, build users