for example another type is produced from this type.
If you want to replace new source you must drop dependent objects before.
and create again that after replaced main type source.
ORA-02303: cannot drop or replace a type with type or table dependents
for example
drop TYPE appuser.table_logtable;
CREATE OR REPLACE
TYPE bankdb.type_hpl_heslog AS OBJECT
(col1 DATE,
col2 VARCHAR2(14)
)
/
CREATE OR REPLACE
TYPE appuser.table_logtable AS TABLE OF type_logtable;
Also you can find dependent object with below sql
select * from dba_dependencies
where name = 'TYPE_LOGTABLE' and owner='APPUSER';
drop type type_name force;
YanıtlaSilif at least one TABLE dependent is present, then FORCE does not allow CREATE or REPLACE TYPE to succeed.
YanıtlaSil