Oracle 12c expdp和impdp匯出匯入表

[oraprod@erpdbp infor]$ expdp CU/CU@PR tables=order,order_operation  dumpfile=expdp.dmp directory=scprd logfile=expdp.log;

[oracle@ebsmiddb infor]$ impdp CU/CU@mid tables=order,order_operation dumpfile=expdp.dmp directory=scprd logfile=expdp.log REMAP_SCHEMA=CU:CU;

1、匯出指定表

expdp 'sys/pwd@server1 as sysdba' directory=dbbak dumpfile=tables.dmp logfile=tables.log 

tables=schema1.table1,schema1.table2

expdp CU/CU@PR tables=order,order_operation dumpfile=expdp.dmp directory=scprd logfile=expdp.log;

2、匯入指定表

--如果源庫和目標庫對應的表空間名稱一樣：

impdp 'sys/pwd@server2 as sysdba' directory=dbbak dumpfile=tables.dmp tables=schema1.table1,schema1.table2  

REMAP_SCHEMA=schema1:schema1

--REMAP_SCHEMA=schema1:schema1，源庫shema:目標庫schema

--如果源庫和目標庫對應的表空間名稱不一樣：

impdp 'sys/pwd@server2 as sysdba' directory=dbbak dumpfile=tables.dmp tables=schema1.table1,schema1.table2  

remap_schema=schema1:schema2 remap_tablespace=tablespace1:tablespace2 

--remap_schema=schema1:schema2，源庫shema:目標庫schema

--remap_tablespace=tablespace1:tablespace2，源表空間：目標表空間