OMF删除表空间

create tablespace trans_tbs;
drop tablespace trans_tbs;
select name from v$datafile;
create tablespace trans_tbs;

drop tablespace trans_tbs including contents;
select name from v$datafile;
create tablespace trans_tbs;

drop tablespace trans_tbs including contents and datafiles;
select name from v$datafile;

OMF自动建立和删除数据文件

create tablespace trans_tbs datafile size 100M;

create tablespace trans_tbs; 
select tablespace_name, bytes/1024/1024 from dba_data_files where tablespace_name='TRANS_TBS';

OMF默认文件大小100M

select * from v$tablespace where name='TRANS_TBS';
select * from dba_data_files where tablespace_name='TRANS_TBS';
select * from dba_tablespaces where tablespace_name='TRANS_TBS';