ORA-08118: Deferred FK constraints cannot be enforced, index too big (string)

ORA-08118: Deferred FK constraints cannot be enforced, index too big (string)
Cause: Deferred Foreign Key constraints cannot be enforced due to the index key being too big and built on a non-default DB_BLOCK_SIZE.
Action: First try to drop the Foreign Key and then the primary key.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:39

ORA-08118：无法实施延迟的FK约束，索引太大（字符串）,
.原因：由于索引键太大并且建立在非缺省DB_BLOCK_SIZE上，因此无法强制执行延迟外键约束。,
.操作：首先尝试删除外键，然后删除主键。,
.

aiaiDBA

13718043309

010-86462881

ORA-08118: Deferred FK constraints cannot be enforced, index too big (string)

1 个回答

相似问题