Wednesday, January 16, 2013

ORACLE Data Pump - expdp & impdp

How to setup directory for data pump expdp at schema level?

CREATE OR REPLACE DIRECTORY DP_DUMP_DIR AS '/bkup/dbname/expdp';
GRANT READ, WRITE ON DIRECTORY DP_DUMP_DIR TO OPER;

col DIRECTORY_PATH for a40;
SELECT * FROM ALL_DIRECTORIES
;



Schema expdp:
expdp oper/pass directory=dp_dump_dir schemas=schemas dumpfile=schema.dmp logfile=schema.log

REMAP_SCHEMA=old_schema:new_schema
REMAP_TABLESPACE=tablespace1:DATA,tablespc2:DATA
DUMPFILE=schema_name_%U.dmp
TRANSFORM=oid:n (expdp X schema from a database and impdp remap_schma to Y schema on SAME database)
PARALLEL=2












No comments:

Post a Comment