expdp,impdp

select * from dba_directories where directory_name='BACKUP_DIR'
CREATE OR REPLACE DIRECTORY backup_dir AS 'e:/wp/';
GRANT READ, WRITE ON DIRECTORY backup_dir TO aak;

expdp aak/aak@16.97/orcl directory=backup_dir dumpfile=tbl_H_full.dmp tables=tbl_H include=constraint,index,trigger query=\"WHERE objectid>2147483647\" logfile=tbl_H_full.log
expdp aak/aak@16.97/orcl directory=backup_dir dumpfile=tbl_H_cond.dmp logfile=tbl_H_cond.log tables=tbl_H query=\"WHERE objectid<2147483647\"

impdp aak/aak@16.96/orcl directory=backup_dir dumpfile=tbl_H_cond.dmp remap_table=tbl_H:tbl_H_NEW logfile=tbl_H_import.log
impdp aak/aak@16.96/orcl directory=backup_dir dumpfile=tbl_H_cond.dmp remap_table=tbl_H:tbl_H_NEW remap_tablespace=aak:aak logfile=tbl_H_import.log

impdp aak/aak@目标数据库IP/orcl directory=backup_dir dumpfile=tbl_H_full.dmp remap_table=tbl_H:tbl_H_NEW include=trigger logfile=tbl_H_import.log