Sunday, January 02, 2011

impdp appending data with query

Trying to retrieve lost records from a datapump backup directly to the production database using impdp syntax:
impdp User/password directory=my_directory dumpfile=my_full_backup.dmp logfile=imp_lost_records.log QUERY=MY_TABLE:\"where code=1 and recid in \(2,5,8\) \" job_name=imp_lost_records INCLUDE=TABLE:\"=\'MY_TABLE\'\" CONTENT=DATA_ONLY TABLE_EXISTS_ACTION=APPEND

1 comment:

Shony said...

see some examples here.
http://shonythomas.blogspot.in/2012/01/oracle-10g-11g-datapump-expdp-query.html