Select file_name
from dba_data_files where tablespace_name=’TEST1_TABLESPACE’;
Select file_name
from dba_temp_files where tablespace_name=’TEMPTEST1_TABLESPACE’;
更改表空間狀態(tài)
Alter tablespace
tablespacename read only/read write/online/offline
查看表空間狀態(tài)
Select status from
dba_tablespaces where tablespacename=’’;
表空間增加/刪除數(shù)據(jù)文件
Alter tablespace test1_tablespace
add datafile ‘test2file.dbf’ size 10m;
Alter tablespace
test1_tablespace drop datafile ‘test2file.dbf’;
刪除表空間
Drop tablespace tablespacename drop tablespace test including contents;