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!

Export selected tables at runtime

Mrshah-OracleOct 19 2011 — edited Oct 22 2011

Hi,

We are planning to write export table query in our oracle 11gr2 database using EXPDP. We want to include only a set of tables, in the export dump file. This set of tables, are stored in master table.

So, at any moment we need to take export of tables which are output of select table_name from master_table

Ex: expdp aa/aa@aa tables='select table_name from tables_to_exp' ...........

Is der any way to achieve this?

Thanks!

This post has been answered by Solomon Yakobson on Oct 22 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 19 2011

Added on Oct 19 2011

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

6 comments

5,365 views