expdp:到处数据命令:
Starting "YLZDBA"."SYS_EXPORT_SCHEMA_01": userid=ylzdba/@kfk19c directory=dir_expdp dumpfile=billms-cs.dmp logfile=billms-cs.log SCHEMAS=billms version=11.2.0.4 COMPRESSION=ALL
pdb impdp:导入数据命令:
导入pdb数据库并更改schema;
impdp dbaits/its@10.41.110.12/pdbbillms directory=dmp dumpfile=billms-cs.dmp REMAP_SCHEMA=billms:BILLMS_TEST
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "BILLMS_TEST"."ACT_CO_DATABASECHANGELOG" 6.140 KB 2 rows
. . imported "BILLMS_TEST"."ACT_CMMN_HI_CASE_INST" 0 KB 0 rows
. . imported "BILLMS_TEST"."BLADE_CODE" 6.554 KB 8 rows
. . imported "BILLMS_TEST"."BLADE_PARAM" 6.140 KB 6 rows
. . imported "BILLMS_TEST"."ACT_ID_MEMBERSHIP" 0 KB 0 rows
. . imported "BILLMS_TEST"."BLADE_SCOPE_DATA" 6.148 KB 1 rows
. . imported "BILLMS_TEST"."ACT_RE_PROCDEF" 0 KB 0 rows
. . imported "BILLMS_TEST"."BLADE_MANUAL" 0 KB 0 rows
. . imported "BILLMS_TEST"."ACT_CMMN_RU_PLAN_ITEM_INST" 0 KB 0 rows