Exclude Parameter in Oracel Data-Pump

Environment : 11gR2 on Windows 2008 Server



>> Export full=y backup and Skip One Table Using ' Exclude ' Parameter.

D:\ iectest_exp_full > expdp directory=iectest_exp_full dumpfile=abc  EXCLUDE=TABLE:\"IN\(\'SHSHTDTA'\)\" full=y


>> From Full=Y backup Skip two Table..

D:\ iectest_exp_full > expdp directory=iectest_exp_full dumpfile=ahph EXCLUDE=TABLE:\"IN\(\'AHTRNHST','PHTRNHST'\)\" full=y

                                             

 >> Skipping 2 Tables from Schema Level Backup

D:\ iectest_exp_full > expdp directory=iectest_exp_full dumpfile=abcd EXCLUDE=TABLE:\"IN\(\'AHTRNHST','PHTRNHST'\)\" schemas=HMIS



Happy Learning...