Impdp example for Table Restore with specific Date Format Condition using par file

 

Hello All,

Assuming We have already full table dump in backups & we have to insert some data with specific condition on dummy table .so We are going threw directly impdp command with par file .

1. First we will create Paramater file with our contition

cat /home/oracle/vvs.dmp

dumpfile=vvs_18Dec2020.dmp
logfile=vvs_18Dec2020_impdp.log
directory=dir1
tables=vvs.vvs_objects
remap_table= vvs.vvs_objects:vvs_objects_impdp
table_exists_action=append
query=vvs.vvs_objects:"where created ='01-JAN-2020'"

2. Impdp Command .

       


impdp system/oracle parfile='/home/oracle/vvs.par';