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-14551: cannot perform a DML operation inside a query

1 Answers  


PCC-02322: found undefined identifier

1 Answers  


RMAN-04001: heap initialization failure

1 Answers  


NNO-00612: enabling request forwarding

1 Answers  


RMAN-06747: at least 1 channel of tertiary storage must be allocated to execute this command

1 Answers  






ORA-06544: PL/SQL: internal error, arguments: [string], [string], [string], [string], [string], [string], [string], [string]

1 Answers  


NNL-00917: Artificial request processing delay: string

1 Answers  


ORA-15034: disk 'string' does not require the FORCE option

1 Answers  


ORA-27475: "string.string" must be a string

1 Answers  


ORA-31505: cannot alter or drop predefined change set

1 Answers  


NCR-03022: NCRO: Cannot send the break

1 Answers  


NNO-00267: warning: configuration database contains no data for server "string"

1 Answers  


Categories