以下转自:http://blog.itpub.net/34596/viewspace-592274/ 作者:myhuaer
A file that is created automatically by the Oracle database server when it is needed and automatically deleted when it is no longer needed.
SQL> show parameter db_create_file_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_create_file_dest string |
[oracle@itc-test9 dbs]more initOCM.ora ....... *.user_dump_dest='/disk/oracle/admin/OCM/udump' db_create_file_dest = '/disk/oracle/oradata' |
使用 ALTER SYSTEM 命令动态设置
SQL> alter system set db_create_file_dest='/disk/oracle/oradata ; System altered. |
SQL> create tablespace omf; Tablespace created. Os: [oracle@itc-test9 datafile]pwd /disk/oracle/oradata/OCM/datafile [oracle@itc-test9 datafile]ll total 102512 -rw-r----- 1 oracle dba 104865792 Apr 29 16:13 o1_mf_omf_4zj30b2p_.dbf |
Name /disk/oracle/oradata/OCM/datafile/o1_mf_omf_4zj30b2p_.dbf Tablespace OMF Status Online File Size (KB) 102400 AutoExtend Yes Increment 100MB Maximum File Size 32767MB |
SQL> alter tablespace omf add datafile; Tablespace altered. Os [oracle@itc-test9 datafile]lltotal 205024 -rw-r----- 1 oracle dba 104865792 Apr 29 16:13 o1_mf_omf_4zj30b2p_.dbf -rw-r----- 1 oracle dba 104865792 Apr 29 16:28 o1_mf_omf_4zj3wj0v_.dbf |
SQL> alter system set db_create_file_dest='/disk/oracle/oradata/OCM' ; System altered. 不做测试了,和前面一样。 |
SQL> drop tablespace omf; Tablespace dropped. [oracle@itc-test9 datafile]ll total 0 |
SQL> drop tablespace noomf including contents and datafiles; Tablespace dropped. |