The following is the ORA-22980 error message, you can learn the cause and solution of the Oracle database error.


ORA-22980 must specify a set of attributes for the WITH OBJECT OID clause

Cause: The WITH OBJECT OID DEFAULT clause was used, but the underlying view or table does not have a OID.

Solution: Specify attributes for the WITH OBJECT OID clause to create a primary key based object identifier for the object view.

Case:

Please wait for the update…