Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Expdp exclude a list of tables from a query

2735689Sep 10 2015 — edited Sep 10 2015

Hi,

I need to exclude some tables in my export. I used this syntax in my parameter file but I found all TEMP tables in the log file:

REUSE_DUMPFILES=YES

CONTENT=DATA_ONLY

SCHEMAS=MYUSER

EXCLUDE=TABLE:"IN (SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME LIKE 'TEMP%' )"                              

QUERY="WHERE NVL(DATEFIELD,SYSDATE-101) > SYSDATE-100"

DIRECTORY=MY_DIRECTORY

Oracle Version 11G

What did I wrong?

Thanks
This post has been answered by Pini Dibask on Sep 10 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2015
Added on Sep 10 2015
#database-key-features, #export-import-sql-loader-external-tables
6 comments
11,822 views