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

Comments

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

Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

Export in Pl/Sql via DBMS_DATAPUMP