oracle RAC 建立使用者和表空間

SQL> create tablespace tbs_test datafile '+DATA/db/datafile/test01.dbf' size 128m
  2  autoextend on next 2048k
  3  maxsize 512m
  4  extent management local uniform. size 2048k
  5  segment space management auto;

Tablespace created.

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
+DATA/db/datafile/users.259.776365283
+DATA/db/datafile/undotbs1.258.776365283
+DATA/db/datafile/sysaux.257.776365283
+DATA/db/datafile/system.256.776365281
+DATA/db/datafile/undotbs2.264.776365753
+DATA/db/datafile/test01.dbf
SQL>  create user test   identified by test
  2   default tablespace tbs_test;

SQL> grant connect ,resource,create table,create session to test;

Grant succeeded.