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

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

    ReplyDelete

Post a Comment

Popular posts from this blog

Data Guard - Changing IP Addresses

Install Oracle Internet Directory (OID) in Standalone mode

Fixing & Registering ORACLE_HOMES in Central Inventory