XDB, SODA_COLLECTION_T are invalid (Doc ID 3031222.1)

Last updated on JUNE 27, 2024

Applies to:

Symptoms

Invalid obects found:

SQL> select owner,object_name,object_type from dba_objects where status='INVALID' and owner='SYS' order by object_name,object_type;

OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------ ------------------------------
SYS DBMS_EPG PACKAGE BODY
SYS DBMS_METADATA_HACK PACKAGE BODY
SYS DBMS_REGXDB PACKAGE BODY
SYS SODA_COLLECTION_T TYPE BODY
SYS XMLBINARYINPUTSTREAM TYPE BODY
SYS XMLBINARYOUTPUTSTREAM TYPE BODY
SYS XMLCHARACTERINPUTSTREAM TYPE BODY
SYS XMLCHARACTEROUTPUTSTREAM TYPE BODY

8 rows selected.

Cause

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