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也会删除
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29990276/viewspace-1647524/ ,如需转载,请注明出处,否则将追究法律责任。