Invalid Streams and Logminer Objects

(Doc ID 1982186.1)

Last updated on MAY 23, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

 The following objects are invalid in the database despite of running catalog/catproc/utlrpto validate them.

 

OWNER                          OBJECT_NAME                    OBJECT_TYPE         STATUS
------------------------------ ------------------------------ ------------------- -------
SYS                            LOGMNR_GTLO3                   PROCEDURE           INVALID
SYS                            LOGMNR_DICT_CACHE              PACKAGE BODY        INVALID
SYS                            DBMS_STREAMS_ADM_UTL           PACKAGE BODY        INVALID
SYS                            DBMS_APPLY_ADM_INTERNAL        PACKAGE BODY        INVALID
SYS                            DBMS_LOGREP_UTIL               PACKAGE BODY        INVALID
SYS                            DBMS_LOGREP_EXP                PACKAGE BODY        INVALID
SYS                            DBMS_LOGREP_IMP_INTERNAL       PACKAGE BODY        INVALID
SYS                            DBMS_XSTREAM_ADM_UTL           PACKAGE BODY        INVALID
SYS                            DBMS_XSTREAM_AUTH              PACKAGE BODY        INVALID
SYS                            DBMS_XSTREAM_ADM_INTERNAL      PACKAGE BODY        INVALID
SYS                            KU$_OPTION_OBJNUM_VIEW         VIEW                INVALID
SYS                            KU$_OPTION_VIEW_OBJNUM_VIEW    VIEW                INVALID

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms