Database Administration (MOSC)

MOSC Banner

DBMS_HM.RUN_CHECK

edited Mar 25, 2019 5:09AM in Database Administration (MOSC) 4 commentsAnswered

Hi

I have run the following  :

  

BEGIN

    DBMS_HM.RUN_CHECK('Dictionary Integrity Check', 'my_run');

END;

and I have found some observations :

Message       : SQL dictionary health check: obj$.type# 47 on object OBJ$

               failed

Message       : Damaged rowid is AAAAASAABAAAEBHAA7 - description: Object

               Name SAAS is referenced

Finding

Finding Name  : Dictionary Inconsistency

Finding ID    : 60

Type          : FAILURE

Status        : OPEN

Priority      : CRITICAL

Message       : SQL dictionary health check: obj$.type# 47 on object OBJ$

               failed

Message       : Damaged rowid is AAAAASAABAAAEBHAA8 - description: Object

               Name PUBLIC_DBAAS is referenced

How i will solve it, Please guide me.

Jewel

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