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
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