ORA-02297: cannot disable constraint (string.string) - dependencies exist

ORA-02297: cannot disable constraint (string.string) - dependencies exist
Cause: an alter table disable constraint failed becuase the table has foriegn keys that are dpendent on this constraint.
Action: Either disable the foreign key constraints or use disable cascade

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-02297：不能禁用约束（字符串。字符串） - 存在依赖关系,
.原因： alter table禁用约束失败，因为表具有此约束上的dpendent的forggn键。,
.操作：禁用外键约束或使用禁用级联,
.

aiaiDBA

13718043309

010-86462881

ORA-02297: cannot disable constraint (string.string) - dependencies exist

1 个回答

相似问题