Oracle Solution for Error ora-30746

Solution for Oracle Error ORA-30746

ORA-30746: error occured while trying to drop column "string

" in table "string

"

What triggered 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

What should we do to fix it:

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