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

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


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.