Q

Export tables into separate dump files

How can I export each table into separate dump files?
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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close