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

ORA-22982 cannot create sub-view under this view

Cause: The view derives its OID from a table/view having primary key based OID and sub-views cannot be created under such views.

Solution: Specify a view having the system generated OID or a view created with the specification of attributes in the WITH OBJECT ID clause and retry the operation.


Please wait for the update…