My Oracle Support Banner

datapatch fails with Error:"ORA-22973: size of object identifier exceeds maximum size allowed" (Doc ID 2284906.1)

Last updated on AUGUST 09, 2018

Applies to:

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

Symptoms

datapatch fails with errors:

Validating logfiles...
Patch 11836540 apply (pdb WP027P): WITH ERRORS
logfile: /opt/oracle/cfgtoollogs/sqlpatch/11836540/21145521/11836540_apply_WC027P_WP027P_2017Jun27_06_33_54.log (errors)
Error at line 7690: ORA-22973: size of object identifier exceeds maximum size allowed
Error at line 7696: ORA-22973: size of object identifier exceeds maximum size allowed
Error at line 7702: ORA-22973: size of object identifier exceeds maximum size allowed
Error at line 7706: Warning: View created with compilation errors.
Error at line 7709: Warning: View created with compilation errors.
Error at line 7712: Warning: View created with compilation errors.

 

Checking the apply log shows these errors:

 select * from ku$_m_view_view_base b
               *
ERROR at line 3:
ORA-22973: size of object identifier exceeds maximum size allowed


 select * from ku$_m_view_view_base b
               *
ERROR at line 3:
ORA-22973: size of object identifier exceeds maximum size allowed


 select * from ku$_m_view_view_base b
               *
ERROR at line 3:
ORA-22973: size of object identifier exceeds maximum size allowed

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!


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