All Oracle Error CodesOracle DBA Forum

ORA-02303:

cannot drop or replace a type with type or table dependents
Cause: 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.
Action: Drop all type(s) and table(s) depending on the type, then retry the operation using the VALIDATE option, or use the FORCE option.
 SubjectReplies
1.10.1.0.4 patchset 2 catcpu.sql slop3
2.10.1.0.4 patchset 2 catcpu.sql slop1