ORA-14652: reference partitioning foreign key is not supported

ORA-14652: reference partitioning foreign key is not supported
Cause: The specified partitioning foreign key was not supported for reference-partitioned tables. All columns of the partitioning foreign key must be constrained NOT NULL with enabled, validated, and not deferrable constraints. Furthermore, a virtual column cannot be part of the partitioning foreign key.
Action: Correct the statement to specify a supported partitioning foreign key.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14652：不支持引用分区外键,
.原因：引用分区表不支持指定的分区外键。分区外键的所有列必须使用enabled，validated和not deferrable约束来约束NOT NULL。此外，虚拟列不能是分区外键的一部分。,
.操作：更正语句以指定支持的分区外键。,
.

aiaiDBA

13718043309

010-86462881

ORA-14652: reference partitioning foreign key is not supported

1 个回答

相似问题