ORA-02440: Create as select with referential constraints not allowed

ORA-02440: Create as select with referential constraints not allowed
Cause: create table foo (... ref. con. ...) as select ...;
Action: Create the table as select, then alter the table to add the constraints afterwards.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-02440：创建为select，不允许使用引用约束,
.原因： create table foo（... ref。con ...）as select ...;,
.操作：将表创建为select，然后更改表以添加约束。,
.

aiaiDBA

13718043309

010-86462881

ORA-02440: Create as select with referential constraints not allowed

1 个回答

相似问题