Oracle Solution for Error ora-22982

ORA-22982: cannot create sub-view under this view

What triggered the Error:

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

What should we do to fix it:

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