Oracle database error code ORA-22982 – cannot create sub-view under this view

Oracle Database Error Code ORA-22982 Description :
cannot create sub-view under this view
Error Cause:
The view derives its OID from a table/view having primary key based OID and sub-views cannot be created under such views.

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


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»