Oracle Database 12c New Features

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.