In this post, you’ll learn more about the Oracle ErrorORA-22973: size of object identifier exceeds maximum size allowed with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-22973: size of object identifier exceeds maximum size allowed
Reason for the Error ORA-22973: size of object identifier exceeds maximum size allowed
Size of the PRIMARY KEY-based object identifier of an object view exceeds the maximum size of 4000 bytes.
How to fix the Error ORA-22973: size of object identifier exceeds maximum size allowed ?
You can fix this error in Oracle by following the below steps
Specify fewer or smaller PRIMARY KEY attributes in the WITH object OID clause when creating the object view.