6 Ocak 2012 Cuma

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

You can't replace type sources if it has dependent object(s).
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';




2 yorum:

  1. drop type type_name force;

    YanıtlaSil
  2. if at least one TABLE dependent is present, then FORCE does not allow CREATE or REPLACE TYPE to succeed.

    YanıtlaSil