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 JANUARY 28, 2020

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

Another case,could be due to Patch rollback and datapatch would fail even if nls_length_semantics="BYTE"

Patch 25296876 rollback (pdb CDB$ROOT): WITH ERRORS
 logfile: $ORACLE_BASE/cfgtoollogs/sqlpatch/25296876/21134475/25296876_rollback_DBNAME_CDBROOT_2019Dec16_14_26_11.log (errors)
   Error at line 715: ORA-22973: size of object identifier exceeds maximum size allowed
   Error at line 746: ORA-22973: size of object identifier exceeds maximum size allowed

Patch 25296876 rollback (pdb PDB$SEED): WITH ERRORS
 logfile: $ORACLE_BASE/cfgtoollogs/sqlpatch/25296876/21134475/25296876_rollback_DBNAME_PDBSEED_2019Dec16_14_29_59.log (errors)
   Error at line 715: ORA-22973: size of object identifier exceeds maximum size allowed
   Error at line 746: ORA-22973: size of object identifier exceeds maximum size allowed

 

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
References


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