dbca刪庫的陷阱

SQL>select * from dba_directories
OWNER       DIRECTORY_NAME          DIRECTORY_PATH
---------- ------------------------------ ----------------------------------------------------------------------------------------------------
SYS       SUBDIR                    /u01/app/oracle/product/11.2.0/db_1/demo/schema/order_entry//2002/Sep
SYS       SS_OE_XMLDIR              /u01/app/oracle/product/11.2.0/db_1/demo/schema/order_entry/
SYS       LOG_FILE_DIR              /u01/app/oracle/product/11.2.0/db_1/demo/schema/log/
SYS       MEDIA_DIR                 /u01/app/oracle/product/11.2.0/db_1/demo/schema/product_media/
SYS       XMLDIR                    /u01/app/oracle/product/11.2.0/db_1/rdbms/xml
SYS       DATA_FILE_DIR             /u01/app/oracle/product/11.2.0/db_1/demo/schema/sales_history/
SYS       DATA_PUMP_DIR             /u01/app/oracle/admin/test/dpdump/
SYS       ORACLE_OCM_CONFIG_DIR      /u01/app/oracle/product/11.2.0/db_1/ccr/state

expdp directory=DATA_PUMP_DIR dumpfile=20150511_emp.dmp logfile=20150511_emp.log schema=emp
cd /u01/app/oracle/admin/test/dpdump/
ls
20150511_emp.dmp  20150511_emp.log  dp.log

DBCA刪庫

/u01/app/oracle/admin/test/dpdump
ls -l

大家要小心啦~~~dbca會清空dump路徑的，測試環境11.2.0.3，低版本的也會
同時spfile initSID.ora也會刪除