Table Level Refresh

Table level data pump imports jobs are probably the most often utilized mode. It is very easy to think in terms of tables when working with data. Table level mode just seems to be the natural granularity of choice.
Return to the prior example of the developer working on code who needs the ability to refresh those tables between runs.

1. Take Export Table from prod database as below

expdp system/manager dumpfile=t1.dmp logfile=t1.log tables=username.tablename directory=d2

2.Copy the table dumpfil from prod to test

scp t1.dmp 11gtest@192.168.26.13:/w_data3/oradata/DATA_PUMP_DIR

3.Drop the table in test

sql>drop table T1 cascade;

4.Import dump file in test

impdp system/manager dumpfile=t1.dmp logfile=t1.log directory =d1 tables=username.tablename

5.After import is completed cross check the no.of rows in prod and test

sql>select count(*) from username.tablename;

Output should be same

###############################################  All The Best ###############################################