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

ERRORcannot drop or replace a type with type or table dependents
CAUSEAn 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.
ACTIONDrop all type(s) and table(s) depending on the type, then retry the operation using the VALIDATE option, or use the FORCE option.

582427Error due to inconsistent Oracle DDIC