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



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

Answer / guest

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

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13149: failed to generate next sequence number for spatial table string

1 Answers  


DRG-50867: failed to free Oracle object

1 Answers  


ORA-23396: database link "string" does not exist or has not been scheduled

1 Answers  


NPL-00419: received ASN.1 object identifier with sub-identifier that is too large

1 Answers  


ORA-23427: deferred purge queue argument string out of range

1 Answers  






NNL-00285: Server has no queued system queries

1 Answers  


ORA-32821: subscriber queue and exception queue must have same payload type

1 Answers  


SQL*Loader-00816: error creating temporary directory object string for file string

1 Answers  


ORA-12153: TNS:not connected

1 Answers  


LFI-00142: Unable to delete an existing file [string][string] not owned by Oracle.

1 Answers  


ORA-26710: incompatible version marker encountered during Capture

1 Answers  


ORA-33308: (DBVALID04) SEVERE ERROR: Record number used but not allocated

1 Answers  


Categories