oracle expdp impdp使用记录

查询系统中的Directory

SELECT * FROM dba_directories

创建新的Directory

CREATE DIRECTORY dmpdir AS '/opt/oracle';
Directory created.

GRANT read, write ON DIRECTORY dmpdir TO scott;
Grant succeeded.

su – oracle

expdp user/password@oracle_sid parfile=ecc_fms_exp.par

impdp user/password@oracle_sid parfile=ecc_fms_imp.par

ecc_fms_exp.par
schemas=ECC_FMS_01
directory=DATA_PUMP_DIR
dumpfile=ecc_fms_without_srpcell.dmp
logfile=ecc_fms_without_srpcell_exp.log
exclude=table:”like ‘SRP_SHEET_CELL__’”
exclude=table:”like ‘SRP_SHEET_CELL___’”

ecc_fms_imp.par
directory=DATA_PUMP_DIR
dumpfile=ecc_fms_without_srpcell.dmp
logfile=ecc_fms_without_srpcell_imp.log
remap_schema=ECC_FMS_01:ECC_FMS_03
# include=TYPE_SPEC
transform=oid:n

Comments are closed.