[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，源表空间：目标表空间