dpimp

Setup a directory object to a shared directory [code language=”sql”] create directory DUMP_FILES as ‘/test/test01’; CREATE OR REPLACE DIRECTORY MY_DIR AS ‘/my_apps/my_files’; [/code] Query code for directories in the database Change the where clause to search for a specific directory [code language=”sql”] select directory_name, directory_path from dba_directories where directory_name=’DATA_PUMP_DIR’; expdp scott/tiger@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.log […]