I am using exp table to backup my own tables. I have schema about 1000 tables where the list can be changed.
There is only one table that is huge in size and I need to export and exclude it.
How can I fix oracle exp table exclude?
In order to exclude certain tables in Oracle using EXP, here is what you can do:
Select table_name
From User_table
Where table_name not in ('Table 1', 'Table2,…)
exp username/pass file=export.dmp paramfile=exclude.par
This command will only exclude TABLES and not functions, view, etc.
If you want them to be excluded, you should specify them explicitly just like what you did in the tables.
Hello,
Here is an example that shows you how to exclude tables from a dump. You should use you user and password to access the database directory to the dump file and use export and exclude as shown below:
C:Users>expdp user/passw@db directory=data_pump_dir dumpÂ
file=export_test.dmp full=y logfile=export_test.log EXCLUDE=TABLE:"LIKE 'OP%'", TABLE:"LIKE '%XYZ%'"Â
Other options in expdpwill exclude the following:Â Using the NOT IN OPERATORÂ
EXCLUDE=TABLE:"NOT IN ('TEMP','TEMP1')"Â
Using the IN OPERATORÂ
EXCLUDE=TABLE:"IN ('TEMP','TEMP1')"Â
Hope this is helpful, good luck.
