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!

Performing an export on multiple tables

792559Aug 19 2010 — edited Feb 8 2011

I'm trying to export multiple tables into a single file where restriction (query) are applied on only one of them:

Command I'm trying:
exp USERID=admin/admin tables=table1, table2 QUERY=\”WHERE param2_1=’set’\”

Desired outcome:
Export file includes all of table1 and rows in table2 where the param2_1 value is 'set'

Restriction/Problem:
As the QUERY statement in export is apparently applied to all tables, the result of my statement is an error that table1 does not contain the specified parameter.

Can anyone suggest a proper method to do this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2011

Added on Aug 19 2010

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

14 comments

33,459 views