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!

EXPDP/IMPDP EXCLUDING ROLES

N88May 17 2013 — edited May 24 2013

Hi All,

I can't call myself new to this forums since I have more than 10 post here but I can call myself new to Oracle databases so please bear with me.

I have a scenario where I need to datapump fron source to target but the issue here is I should not export any connect,resource,dba roles associated with the users.

Can anyone help me what needs to be excluded during the initial export to avoid them being imported on the target.

Thanks in advance for your help,

-N

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 21 2013

Added on May 17 2013

#and, #database-key-features, #export, #export-import-sql-loader-external-tables, #import

6 comments

6,543 views