Oracle DB Error ORA-22982 cannot create sub-view under this view

The following is the cause of this error:

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

Action you can take to resolve this issue: 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.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related