Skip to Main Content

Oracle Database Discussions

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!

Objects are getting invalid after compiling schema

3309509Oct 14 2019 — edited Oct 15 2019

Hello,

We have found one strange issue in our development environment.

We have one schema in which we have 2-3 invalid objects. Whenever we are executing DBMS_UTILITY.COMPILE_SCHEMA for that schema then all the procedures, packages, functions status are changing to INVALID stats.

Our development database version is 10.2.0.5.

I know it is an older version. We are going to move to 12c in a short time.

Any help will be appreciated.

Thanks.

Comments
Post Details
Added on Oct 14 2019
7 comments
527 views