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!

using multiple tables in a query clause in expdp

Ed CharterDec 12 2013 — edited Dec 12 2013

Is it possible to use multiple table in a query option of expdp? I am trying to do the following and it is failing with the message "Invalid identifier" i am using Oracle 10 version 10.2.0.3

Parameter file (x.par)

************************

DIRECTORY=DATA_PUMP_DIR

USERID=XYZ/XYZ@DB1

DUMPFILE=X.DMP

LOGFILE=X.LOG

CONTENT=DATA_ONLY

TABLES="TAB1"

QUERY= TAB1:"WHERE EXISTS (SELECT 1 FROM TAB2 WHERE TAB2.KEYID=TAB1.KEYID)"

expdp parfile=x.par

Error

******

ORA-00904: "TAB1"."KEYID": invalid identifier

Please share your thoughts

Thanks

This post has been answered by Ed Charter on Dec 12 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 9 2014

Added on Dec 12 2013

#database-key-features, #export-import-sql-loader-external-tables

2 comments

1,376 views