How to exclude list of the tables while taking export using EXPDP.

   Here we go..  

We can use EXCLUDE  2 ways.

1. if Number of exclude table list is very less

2. if Number of exclude tables are more ...

if your scenario is first option you can simply use table names in exclude option.

if your scenario is second option 

first of all we need to take  list of tables and create temporary table with one column table_name and insert all table names into temporary table.

Here my temporary table is "exclude_olsm_gx_nyps". the only thing mandatory thing we need to follow is we must create PARFILE whenever we want to use EXCLUDE with sql query like below..

cat>uat.par

schemas=uat_master_711

dumpfile=uat_master_711_%u.dmp

logfile=expdp_uat_master_711.log

directory=st1

parallel=4

EXCLUDE=TABLE:"in (select table_name from ops$oracle.exclude_olsm_gx_nyps)"

we can simply use uat.par with EXPDP utility..  

when you learn something new just share it..

Thanks,

Anil vejendla,

ORACLE DBA.