Oracle Error Message
ORA-22973: size of object identifier exceeds maximum size allowed
Reason for the Error
Size of the PRIMARY KEY-based object identifier of an object view exceeds the maximum size of 4000 bytes.
Solution
Specify fewer or smaller PRIMARY KEY attributes in the WITH object OID clause when creating the object view.
