Oracle Solution for Error ora-22973

Solution for Oracle Error ORA-22973

ORA-22973: size of object identifier exceeds maximum size allowed

What triggered the Error:

ze of the PRIMARY KEY-based object identifier of an object view exceeds the maximum size of 4000 bytes.

What should we do to fix it:

ecify fewer or smaller PRIMARY KEY attributes in the WITH object OID clause when creating the object view.