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.