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

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

0 Answers   Wipro,


ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

1 Answers  


ORA-09930: LUB of two labels is invalid

1 Answers  


ORA-01320: Invalid Logminer dictionar attribute

1 Answers  


ORA-16561: Cannot remove an active instance.

1 Answers  






ORA-28522: error initializing heterogeneous capabilities

1 Answers  


ORA-07244: ssfccf: create file failed, file size limit reached.

1 Answers  


DRG-50861: failed to obtain type descriptor

1 Answers  


IMP-00023: Import views not installed, please notify your DBA

1 Answers  


ORA-32059: deadlock detected on mapping structures

1 Answers  


ORA-13344: an arcpolygon geometry has fewer than five coordinates

1 Answers  


DRG-11840: Not Implemented

1 Answers  


Categories