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 explicit grants on SYS objects

Mimi MiamiJul 31 2014 — edited Aug 1 2014

I'm running a full expdp/impdp as system on my 11.2 Oracle database. I understand explicit grants on SYS objects do not get exported. How do I find the list of explicit grants given on SYS objects so I can recreate them manually on my new database?

What other things do not get exported when doing full=Y that I am required to recreate manually?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2014

Added on Jul 31 2014

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

6 comments

3,989 views