Exclude clause with Expdp

Hello all,
I've got an issue here. I am exporting an schema with expdp and I want to exclude few tables for the export. Exclude clause lets me use Like operator only once but I need to exclude different types of tables where I'd need to use more than one Like operator. I am on oracle 10gR2, RHEL 3. My expdp command looks something like this:

expdp DIRECTORY='IMP_DIR' DUMPFILE='Emp.DMP' LOGFILE='Emp.LOG' SCHEMAS=Emp; EXCLUDE=TABLE:\"LIKE \'T1_%\' or LIKE \'T2_%\'\"
:P it didn't work out.

Please advice.

See if (maybe) this works:

EXCLUDE=TABLE:\"LIKE \'T1_%\'\", TABLE:\"LIKE \'T2_%\'\"
:confused:

Thanks LKBrwn_DBA. It does give me what I wanted with expdp. Thanks again.:) :)

Maybe you can get rid of the 'escape' characters:

EXCLUDE=TABLE:"LIKE 'T1_%'", TABLE:"LIKE 'T2_%'"

:p

Visit here for more details & examples.
http://shonythomas.blogspot.com/2011...clude-and.html