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!

Database Idea: Add a warning about SYS owned objects not exported/imported

In data pump expdp or impdp, grants on SYS owned objects are not exported/imported according to

Data Pump: GRANTs On SYS Owned Objects Are Not Transferred With Data Pump And Are Missing In The Target Database (Doc ID 1911151.1)

unless you run data pump as sys, which is not recommended or even supported. It would be nice if at the end of expdp or impdp, we see a one-line warning like "grants on SYS owned objects to the users exported/imported are found" so that we know we should make the grants manually after the import. Without this warning, it's too easy to forget this important step that could cause a failure of a business process. Adding this warning to the data pump utilities is very easy and it has great benefit.

Comments
Post Details
Added on Apr 3 2023
0 comments
327 views