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.