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

NNL-00811: Fastest query processing time: string

1 Answers  


PCC-01513: FIPS warning: Unsupported datatype in line number of file string

1 Answers  


DRG-11619: URL store: row in table is empty

1 Answers  


ORA-16606: unable to find property "string"

1 Answers  


TNS-01064: Listener configuration changes will not be persistent

1 Answers  


ORA-38470: cannot revoke a privilege that was not granted.

1 Answers  


QSM-01018: single table materialized join view rewrite not required

1 Answers  


ORA-31492: could not set session parameters for LogMiner session

1 Answers  


ORA-10565: Another test recovery session is active

1 Answers  


DRG-11525: invalid commitafter parameter of string specified

1 Answers  


ORA-29370: pending area is already active

1 Answers  


ORA-24082: propagation may still be happening for the schedule for QUEUE string and DESTINATION string

1 Answers  


Categories