Database Administration (MOSC)

MOSC Banner

Invalid Objects SYSMAN

Hello All !


Got an alert about Invalid Object on my Database.
Both objects on SYSMAN are invalid :
PACKAGE BODY
DBPROV_INIT

Here is my version :

Database : Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production


When I try to compile and show errors, I have :
SQL> alter package SYSMAN.DBPROV_INIT compile body;

Warning : Package body modified with compilation error

SQL> show error;
Erreurs pour PACKAGE BODY SYSMAN.DBPROV_INIT :

LINE/COL ERROR
-------- -----------------------------------------------------------------
39/1     PL/SQL: SQL Statement ignored
39/13    PL/SQL: ORA-00942: Table or view missing
70/3     PL/SQL: SQL Statement ignored
70/11    PL/SQL: ORA-00942: Table or view missing
106/1    PL/SQL: SQL Statement ignored
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center