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

NNL-00264: Request forwarding is now disabled

1 Answers  


QSM-02099: mv references a remote table or view in the FROM list

1 Answers  


RMAN-08066: database reset to incarnation string

1 Answers  


ORA-03299: cannot create dictionary table string

1 Answers  


PLS-00253: Formal parameter string missing in the parameters clause

1 Answers  






RMAN-06410: cannot use command when channels are allocated

1 Answers  


ORA-07584: spdcr: invalid value for ORA_sid_(proc_)PQL$_item

1 Answers  


ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

1 Answers  


ORA-22887: type of REF column is not the same as that of its scoped table

1 Answers  


ORA-16775: Target standby in switchover operation has missing redo logs.

1 Answers  


ORA-30509: client logoff triggers cannot have AFTER type

1 Answers  


ORA-02710: osnpop: fork failed

1 Answers  


Categories