Oracle Error ORA-33313: (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.

Oracle Error Message

ORA-33313: (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.

Reason for the Error

User attempted to delete a variable, but some partitioned variable was defined to use that variable as the target of one of its external partitions.

Solution

DELETE the partitioned variable or CHGDFN DROP PARTITION the the external partition from the partitioned variable, then delete the target variable.