Oracle Learning notes continue to update

1. CREATE TABLE Space Data_basic

(1) Orale User Login System

(2) Sqlplus/as sysdba; DBA User Login database;

Execution: Create tablespace tab_sts_basic datafile '/oracle/app/uboss/oradata/uboss/datafile/uboss_def01.dbf' Size 512M; --The path should be modified according to actual situation;

SELECT * from Dba_data_files can find the data file storage path

2. Create a database user and give permissions

Create Test_user, table space specified as Data_basic

(1) Create user Test_user identified by "Test_user" default tablespace data_basic temporary tablespace TEMP profile default ;

granting permissions

Grant connect to Test_user;

Grant DBA to Test_user;

Grant resource to Test_user;

http://blog.csdn.net/rznice/article/details/6683905/

http://blog.csdn.net/small____fish/article/details/7920126

Oracle Learning notes continue to update