Oracle Database Discussions

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 dump only 1000 tables from the schema which contains 3000 tables.

475839Sep 24 2010 — edited Sep 27 2010

Hi,

I have an requirement to export the dump only with particular 1000 tables from the schema which contains 3000 tables.

As I want to take the dump, I need to mention the List of tables in "TABLES" Parameter. But syntax won't allow for 1000 tables.

Kindly guide me on this to proceed further to take the dump of only particular 1000 tables.

Thanks in advance.

Thanks,
Orahar.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2010

Added on Sep 24 2010

#dba, #general-database-discussions, #oracle

10 comments

1,124 views