INVALID SYS OBJECTS In PDB (Doc ID 2191949.1)

Last updated on DECEMBER 06, 2016

Applies to:

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

Symptoms

There are invalid SYS Objects in the PDB.
UTLRP does not resolve this.
Alter...Compile gives an ORA-65047

SQL> show con_id

CON_ID
------------------------------
3

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

OWNER OBJECT_TYPE OBJECT_NAME STATUS
---------- ----------------------- ------------------------------ --------------------
SYS TYPE extra_attribute_values52_T INVALID
SYS TYPE extra_attribute_valu47_COLL INVALID
SYS TYPE extra_attribute_values46_T INVALID


SQL> alter type SYS."extra_attribute_values52_T" compile;
alter type SYS."extra_attribute_values52_T" compile
*
ERROR at line 1:
ORA-65047: object SYS.extra_attribute_valu47_COLL is invalid or compiled with errors in CDB$ROOT

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