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;
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;
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/，如需转载，请注明出处，否则将追究法律责任。
下一篇：
RAC 客戶點配置
请登录后发表评论
登录
全部评论
