Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-02303 – cannot drop or replace a type with type or table dependents

Oracle Database Error Code ORA-2303 Description :

cannot drop or replace a type with type or table dependents

Error 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.

How to Solve :

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