How can I export each table into separate dump files?

    Requires Free Membership to View

If you want to export a table into its own dump file, then you will have to invoke the exp utility for each table. Something similar to the following:

exp userid=system/manager tables=scott.emp file=emp.dmp exp userid=system/manager tables=scott.dept file=dept.dmp

In those two commands, the two generated dump files will contain only one table.

This was first published in March 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.