exp

Expdp

oracle export exp expdp

See all directories 1 SELECT * FROM all_directories ORDER BY directory_path; Create a new directory and grant access 1 2 CREATE OR REPLACE DIRECTORY EXPORT_DIR AS '/u01/export/'; GRANT READ, WRITE ON DIRECTORY test_dir TO XXX; Export a schema 1 expdp system/password@sid schemas=XXX directory=EXPORT_DIR dumpfile=XXX.dmp logfile=XXX.log parallel=3 Export a database 1 expdp system/password@sid full=Y directory=EXPORT_DIR dumpfile=XXX.dmp logfile=XXX.log parallel=3 Kill a expdp job