-
Export tables and indexes using Data Pump
Hi folks,
I'm trying to export only tables and indexes of a schema using Data Pump utility (expdp).
I don't want to use the parameter tables=t1,t2,t3 ...,tn because I want to take all tables and their indexes.
Which parameters I should use in the expdp command for this purpose?
Thanks in advance,
Nir
-
Just expdp your target schema.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
type expdp help=y
check this link you will get some details to take the export
http://www.oracle-base.com/articles/...hp#TableExpImp
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|