ORA-22982: cannot create sub-view under this view Cause: The view derives itsOID from a table/view having primary key based
OID and sub-views cannot be created under such views. Action: Specify view havingsystem generated OID or a view created with the
specification of attributes in the WITH OBJECT ID clause and retry theoperation.