Oracle Database Discussions

Hi all,

i've been reading through documentation and googling and just cant get it :( :( , so i'm asking for your help

I want to export a database, full export, but i want to exclude two tables. Those tables are in one specific schema , this schema it's named AUDAFLOW

the tables i want to exclude are:

ESTIMATION_CONTROL
ESTIMATION

My code:

expdp system/XXXX directory=backup_dir dumpfile=exp_diario.dmp logfile=exp_diario.log exclude=table:\"in (\'AUDAFLOW.ESTIMATION_CONTROL\',\'AUDAFL
OW.ESTIMATION\')\" full=y job_name=export_diario_oracr

This does not work, i get an full export... somehow expdp ignores the exclude parameter :(

Another Shot:

i removed the schema name in the exclude parameter.

expdp system/XXXX directory=backup_dir dumpfile=exp_diario.dmp logfile=exp_diario.log exclude=table:\"in (\'ESTIMATION_CONTROL\',\'ESTIMATION\')\" full=y job_name=export_diario_oracr

This way i get an full export and the table ESTIMATION_CONTROL is EXCLUDED !! yeeeahhh !!!

Now, i have a problem .... there is several tables with the name ESTIMATION ( i have TROIA.ESTIMATION , WORKMG.ESTIMATION, AUDAFLOW.ESTIMATION).

i'm confused ... is it possible or not to do a full export and exclude specific tables in specific schemas ?

Best regards

Rui MAdaleno

My environment
Oracle 11gR2
windows 2008 Enteprise 64bit