使用OMF自动创建DBF

SQL> alter system set db_create_file_dest='/u01/app/oracle/oradata/southdb' scope=both;

System altered.

SQL> alter system set db_create_online_log_dest_1='/u01/app/oracle/oradata/southdb' scope=both;

System altered.

SQL> create tablespace omar extent management local uniform size 1m segment space management auto;

Tablespace created.

SQL> select name,bytes/1024/1024||'M' from v$datafile;

NAME BYTES/1024/1024||'M'
---------------------------------------------------------------------- -----------------------------------------
/u01/app/oracle/oradata/southdb/system01.dbf 1024M
/u01/app/oracle/oradata/southdb/undotbs01.dbf 4096M
/u01/app/oracle/oradata/southdb/sysaux01.dbf 1024M
/u01/app/oracle/oradata/southdb/users01.dbf 4096M
/u01/app/oracle/oradata/southdb/rbs01.dbf 2000M
/u01/app/oracle/oradata/southdb/rbs02.dbf 400M
/u01/app/oracle/oradata/southdb/rbs03.dbf 400M
/u01/app/oracle/oradata/southdb/rbs04.dbf 400M
/u01/app/oracle/oradata/southdb/indx01.dbf 20M
/u01/app/oracle/oradata/southdb/drsys01.dbf 20M
/u01/app/oracle/oradata/southdb/comm_data01.dbf 200M
/u01/app/oracle/oradata/southdb/phs_data01.dbf 250M
/u01/app/oracle/oradata/southdb/phs_data02.dbf 250M
/u01/app/oracle/oradata/southdb/phs_data03.dbf 250M
/u01/app/oracle/oradata/southdb/phs_data04.dbf 250M
/u01/app/oracle/oradata/southdb/webdev_data01.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data02.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data03.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data04.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data05.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data06.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data07.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data08.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data09.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data10.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data11.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data12.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data13.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data14.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data15.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data17.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data18.dbf 2000M
/u01/app/oracle/oradata/southdb/webdev_data19.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data01.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data02.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data03.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data04.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data05.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data06.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data07.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data08.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data09.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data10.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data11.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data12.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data13.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data14.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data16.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data17.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data18.dbf 2000M
/u01/app/oracle/oradata/southdb/mobile_data19.dbf 2000M
/u01/app/oracle/oradata/southdb/SOUTHDB/datafile/o1_mf_omar_3f75d2bp_. 100M
dbf

52 rows selected.

SQL>

SQL> drop tablespace omar ;