Oracle Solution for Error ora-02303

ORA-02303: cannot drop or replace a type with type or table dependents

What triggered the Error:

An attempt was made to drop or replace a type that has dependents. There could be a substitutable column of a supertype of the type being dropped.

What should we do to fix it:

Drop all type(s) and table(s) depending on the type, then retry the operation using the VALIDATE option, or use the FORCE option.