reference partitioning foreign key is not supported

Solution ID:ORA-14652

Type: Oracle

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.

Actions

Reissue the command after ensuring that the two subpartitions being merged lie in the same composite partition.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/10105276


https://community.oracle.com/message/11049887


Browse all solutions to database errors from Oracle, MS SQL, or MySQL