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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-02424：潜在的圆视图引用或未知的引用表,
.原因： create schema语句包含依赖于包含create schema语句中的其他视图或包含对未知表的引用的视图。,
.操作：在单独的create schema语句中创建依赖视图，并确保所有引用的表都在create schema语句中定义或存在于语句之外。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题