Tag Archives: ORA-02303

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

oracle

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/