Skip to Main Content

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!

How to export (with expdp) all non-default users and dependent stuff?

pstein-JavaNetMar 21 2009 — edited Apr 2 2009
Ok, I could export all content from user aaa with a command like:

expdp userid=aaa file mydumpfile.dmp

But how do I export in addition the user and all his grants and definitions itself as well?

How do I dump ALL non-default (newly created) users and their dependent tables alltogether in one dumpfile?

Assume I don't know all of them or won't export them individually step by step.

Peter
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2009
Added on Mar 21 2009
6 comments
3,232 views