ORA-22981: must specify a table/view having system generated OID



ORA-22981: must specify a table/view having system generated OID..

Answer / guest

Cause: The super-view is based on a table/view having the
system generated OID and the sub-view must also be based on
a similar table/view.

Action: Specify table/view having system generated OID and
retry the 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-16174: user requested thread/sequence termination of managed recovery

1 Answers  


QSM-02044: ORDER BY clause in mv

1 Answers  


NNC-00050: message format error

1 Answers  


ORA-01285: error reading file string

1 Answers  


ORA-00226: operation disallowed while alternate controlfile open

1 Answers  






RMAN-04032: using contents of file string

1 Answers  


ORA-01208: data file is an old version - not accessing current version

1 Answers  


ORA-00208: number of controlfile names exceeds limit of string

1 Answers  


ORA-30039: Cannot drop the undo tablespace

1 Answers  


ORA-16120: dependencies being computed for transaction at SCN string

1 Answers  


ORA-24311: memory initialization failed

1 Answers  


ORA-31039: XML namespace length string exceeds maximum string

1 Answers  


Categories