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