Oracle Error ORA-14668: Cannot drop a unique or primary key referenced by the partitioning constraint of a reference-partitioned table.

Oracle Error Message

ORA-14668: Cannot drop a unique or primary key referenced by the partitioning constraint of a reference-partitioned table.

Reason for the Error

An attempt was made to drop a unique or primary key referenced by the partitioning constraint of a reference-partitioned table.

Solution

Drop all reference-partitioned child tables before dropping the unique or primary key of the parent table.