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

I was looking everywhere for the syntax also, but was having a hard time finding the documentation. From the page that Codo linked... notice that the FORCE is between the object name and as object

create or replace type ceq_owner.type_rec_parae2 FORCE as object    
(
  ...
  BONETAT_DESC  VARCHAR2(250),
  ... 
)
/ 

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.


Try:

drop type your_type force;

Tags:

Oracle

Plsql