Oracle Error ORA-34177: (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it.

Oracle Error Message

ORA-34177: (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it.

Reason for the Error

User attempted to CHGDFN DELETE a partition template, but some partitioned variable had data in the partition specified for deletion.

Solution

Drop the partitions that are causing the problem, then retry.