Oracle Error Codes

potential circular view references or unknown referenced tables

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

How to Solve :

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.