ORA-02424: potential circular view references or unknown
referenced tables



ORA-02424: potential circular view references or unknown referenced tables..

Answer / guest

Cause: the create schema statement contains views that
depend on other views in the containing create schema
statement or they contain references to unknown tables.

Action: create the dependent views in a separate create
schema statement and make sure all referenced tables are
either defined in the create schema statement or exist
outside the statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-11440: operation not supported for the string language

1 Answers  


QSM-02179: MV with UNION ALL requires compatibility >= 9.2

1 Answers  


RMAN-06164: WARNING: no channel of required type allocated to recover datafile number

1 Answers  


NNO-00074: downloading region from server string

1 Answers  


ORA-01034: ORACLE not available

1 Answers  






PCC-01002: Invalid character "character" in indicator area at line number in file string

1 Answers  


IMG-02005: 2FF05 - incorrect color specification

1 Answers  


PCC-00014: Undeclared SQL Identifier "string" at line number in file string

1 Answers  


ORA-02875: smpini: Unable to get shared memory for PGA

1 Answers  


ORA-16026: parameter string contains an invalid attribute value

1 Answers  


RMAN-06000: could not open recovery manager library file: string

1 Answers  


ORA-00311: cannot read header from archived log

1 Answers  


Categories