ORA-02303: cannot drop or replace a type with type or table dependents
oracle, plsql
Solution
There are other types or tables that depend on the type you want to change. If it's a dependent type, then you can use the FORCE option to change the type.
If it's a table that directly or indirectly uses the type, then you will need to create a new type and a new table, migrate all the data, and finally drop and rename tables and types.
See this Oracle documentation for some further information.
Problem
I'm newbee in oracle and I try to change `varchar(50)` to `250` ``` CREATE OR REPLACE TYPE CEQ_OWNER.TYPE_REC_PARAE2 AS OBJECT ( ... BONETAT_DESC VARCHAR2(250), ... ) / ``` I get ORA-02303: cannot drop or replace a type with type or table dependents