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

ORA-01225: thread number string is greater than MAXINSTANCES string

1 Answers  


NNL-00535: reload [<server_list>] : reload server cache data if there are changes

1 Answers  


NNL-00993: Auto-refresh failure retry expiration: string

1 Answers  


ORA-00053: maximum number of enqueues exceeded

1 Answers  


ORA-38486: FUNCTION/PACKAGE/TYPE already exists for the attribute set

1 Answers  






ORA-25249: dequeue failed, dequeue not allowed for queue string.string

1 Answers  


NNL-01076: Operational Status number

1 Answers  


PLS-00630: pipelined functions must have a supported collection return type

2 Answers  


ORA-23387: replication parallel push dequeue error

1 Answers  


NNC-00002: error listening on stream string

1 Answers  


DRG-52201: imcompatible Oracle Text versions

1 Answers  


ORA-22057: bad integer length [string]

1 Answers  


Categories