SQL> select file_id,file_name,tablespace_name from dba_data_files;
FILE_ID FILE_NAME TABLESPACE_NAME
---------- ------------------------------------- -----------------
4 +SYS_DATA/oratest/users01.dbf USERS
3 +SYS_DATA/oratest/sysaux01.dbf SYSAUX
2 +SYS_DATA/oratest/undotbs01.dbf UNDOTBS1
1 +SYS_DATA/oratest/system01.dbf SYSTEM
SQL> create tablespace study datafile '+USER_DATA/oratest/study.dbf' size 30M
2 extent management local segment space management auto;
Tablespace created
SQL> select file_id,file_name,tablespace_name from dba_data_files;
FILE_ID FILE_NAME TABLESPACE_NAME
---------- ----------------------------------- -----------------
4 +SYS_DATA/oratest/users01.dbf USERS
3 +SYS_DATA/oratest/sysaux01.dbf SYSAUX
2 +SYS_DATA/oratest/undotbs01.dbf UNDOTBS1
1 +SYS_DATA/oratest/system01.dbf SYSTEM
5 +USER_DATA/oratest/study.dbf STUDY
SQL> select group_number,name,state,type,total_mb,free_mb from v$asm_diskgroup;
GROUP_NUMBER NAME STATE TYPE TOTAL_MB FREE_MB
------------ -------------- ----------- ------ ---------- ----------
1 FLASH_DATA MOUNTED EXTERN 400 346
2 SYS_DATA CONNECTED EXTERN 1500 466
3 TEST_DATA MOUNTED HIGH 300 147
4 USER_DATA CONNECTED NORMAL 200 32
SQL>
SQL> create user study identified by study default tablespace study quota unlimited on study;
User created
SQL> grant connect,resource,dba to study;
Grant succeeded
SQL> conn study/study@oratest
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as study
SQL>
接下来,你就可以随便的折腾了!
(第三部分完)