Invalid SYS-Owned Text Objects / How To Remove Text Objects From The SYS Schema When Text Is Installed/In Use? (Doc ID 1313273.1)

Last updated on JANUARY 22, 2024

Applies to:

Symptoms

One or more of the following SYS-owned objects are invalid:

OWNER      OBJECT_NAME               OBJECT_TYPE     STATUS
---------- ------------------------- --------------- ----------
SYS        CATINDEXMETHODS           TYPE BODY       INVALID
SYS        CATSEARCH                 OPERATOR        INVALID
SYS        CONTAINS                  OPERATOR        INVALID
SYS        DR$OPTTF_IMPL_T           TYPE BODY       INVALID
SYS        DRUE                      PACKAGE BODY    INVALID
SYS        DRVDDL                    PACKAGE BODY    INVALID
SYS        DRVDDLC                   PACKAGE BODY    INVALID
SYS        DRVDDLR                   PACKAGE BODY    INVALID
SYS        DRVDDLX                   PACKAGE BODY    INVALID
SYS        DRVDML                    PACKAGE BODY    INVALID
SYS        DRVDOC                    PACKAGE BODY    INVALID
SYS        DRVIMR                    PACKAGE         INVALID
SYS        DRVIMR                    PACKAGE BODY    INVALID
SYS        DRVODM                    PACKAGE BODY    INVALID
SYS        DRVPARX                   PACKAGE BODY    INVALID
SYS        DRVRIO                    PACKAGE BODY    INVALID
SYS        DRVTMT                    PACKAGE BODY    INVALID
SYS        DRVUTL                    PACKAGE BODY    INVALID
SYS        DRVXMD                    PACKAGE BODY    INVALID
SYS        DRVXTAB                   PACKAGE BODY    INVALID
SYS        DRVXTABC                  PACKAGE BODY    INVALID
SYS        DRVXTABR                  PACKAGE BODY    INVALID
SYS        DRVXTABX                  PACKAGE BODY    INVALID
SYS        MATCHES                   OPERATOR        INVALID
SYS        MATCH_SCORE               OPERATOR        INVALID
SYS        RULEINDEXMETHODS          TYPE BODY       INVALID
SYS        SCORE                     OPERATOR        INVALID
SYS        TEXTINDEXMETHODS          TYPE BODY       INVALID
SYS        XPATHINDEXMETHODS         TYPE BODY       INVALID
SYS        XPCONTAINS                OPERATOR        INVALID

~AND~

DBA_REGISTRY content shows Oracle Text is installed, for example:

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.