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/,如需转载,请注明出处,否则将追究法律责任。