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 MAY 17, 2023
Applies to:
Oracle Text - Version 11.2.0.4 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |