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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 8 2011
Added on Aug 19 2010
#database-key-features, #export, #export-import-sql-loader-external-tables, #query
14 comments
32,915 views