Skip to Main Content

Database Software

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!

schema backup - which user should I use?

awildiacMay 20 2015 — edited May 20 2015

Hi

I'm planning to backup a schema with Datapump for the first time, I do understand that under normal circumstances I would typical invoke expdp with the user that owns the schema I'm backing up. For an example for backing up the hr schema I should connect with the hr account "expdp hr parfile=hr.par". (I plan to use a parameter file).

But if I'm not using the account that owns the schema I'm backing up or exporting. Which user should I use, what is considered best practice? Should I use sys or system, or sys with as sysdba. Any feedback would be greatly appreciated.

/A

This post has been answered by EdStevens on May 20 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2015
Added on May 20 2015
6 comments
1,415 views