Oracle Error ORA-30746: error occured while trying to drop column “string” in table “string”

Oracle Error Message

ORA-30746: error occured while trying to drop column “string” in table “string”

Reason for the Error

The user tried to drop a subtype with VALIDATE option which tried to check for stored instances of the type in the stated table

Solution

Delete all instances of this subtype and then drop the type.