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-13765: Value "string" is illegal for a result limit.

1 Answers  


ORA-01350: must specify a tablespace name

1 Answers  


NNL-00524: Replaces a data item with another data item

1 Answers  


ORA-01078: failure in processing system parameters

1 Answers  


NNL-00047: LDAP modify returned error: 0xnumber, string

1 Answers  






DRG-12516: language column must be specified when using the multi stoplist

1 Answers  


EXP-00084: Unexpected DbmsJava error number at step number

1 Answers  


ORA-02788: Unable to find kernel process pointer in async process array

1 Answers  


PLS-01712: ANSI does not allow bind variables as INDICATORS

1 Answers  


PCC-02066: CMD-LINE: Could not find or could not open system config file

1 Answers  


ORA-30370: set operators are not supported in this context

1 Answers  


ORA-14073: bootstrap table or cluster may not be truncated

1 Answers  


Categories