Duplicate Invalid Types That Won't Compile (Doc ID 748109.1)

Last updated on DECEMBER 07, 2016

Applies to:

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

Symptoms

After a database upgrade the following objects may be reported as invalid:

OWNER OBJECT_NAME OBJECT_TYPE STATUS
SYS AQ$_DESCRIPTOR TYPE INVALID
SYS AQ$_EVENT_MESSAGE TYPE INVALID
SYS AQ$_REG_INFO TYPE INVALID
SYS AQ$_REG_INFO_LIST TYPE INVALID
SYS AQ$_SRVNTFN_MESSAGE TYPE INVALID
SYS DBMS_XPLAN_TYPE TYPE INVALID
SYS DBMS_XPLAN_TYPE_TABLE TYPE INVALID
SYS LCR$_ROW_LIST TYPE INVALID
SYS LCR$_ROW_UNIT TYPE INVALID
SYS MSG_PROP_T TYPE INVALID
SYS XMLGENFORMATTYPE TYPE INVALID

Cause

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