oracle RAC 創建用戶和表空間

Linux操作系统作者：weibingzhou 时间：2015-09-23 12:39:10 0 删除编辑

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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24447726/viewspace-1807079/，如需转载，请注明出处，否则将追究法律责任。