Target：
Backup data from table ‘soa.soa_archive’ host1 db:SOA to host2 db:HIST
part1:
nohup expdp jbian/Maya@host1/SOAPB2B directory=EXPDP tables=SOA.SOA_ARCHIVE query=’SOA.SOA_ARCHIVE：”WHERE SOA_ARCHIVE_ID > 33655665″‘ dumpfile=SOA.SOA_ARCHIVE%U.dmp logfile=SOA.SOA_ARCHIVE.log parallel=16 > SOA_ARCHIVE.log &
part2:
nohup expdp \’/ as sysdba\’ parfile=soa_archive_1.par > soa_archive_1.log &
#cat soa_archive_1.par
query=SOA.SOA_ARCHIVE：”WHERE SOA_ARCHIVE_ID > 25905139 and SOA_ARCHIVE_ID<=33655665″
tables=SOA.SOA_ARCHIVE
directory=EXPDP
dumpfile=SOA.SOA_ARCHIVE_2_%U.dmp
logfile=SOA.SOA_ARCHIVE_2.log
parallel=16