2 Replies Latest reply: Nov 9, 2012 9:21 AM by vlethakula RSS

    Where can I find information on the database_upgrade package?

      I had an issue with a package that wouldn't compile in an upgraded ( to database, it gave out "ORA-01031: Insufficient Privileges".

      A consultant used "exec database_upgrade.grantaccess('SCHEMA','OBJECT');" which created all the necessary grants and fixed it.

      I've tried to find the documentation on this package, but it doesn't exist (a google and bing search shows nothing, and it's not in the Database PL/SQL Packages and Types Reference manual online, and MOS has nothing).

      I can do a desc on it, but I'd really like to know more about it as I'm about to upgrade several databases over the next few months.

      Does anyone know where I can find info on it?