Monthly Archives: December 2017
oracle expdp impdp使用记录
查询系统中的Directory 创建新的Directory 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
Feed订阅