ORA-02303: Cannot Drop Or replace A Type With Type Or Table Dependents When Doing Configuring DSI Import (Doc ID 604974.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Thesaurus Management System - Version 4.6.0 and later
Information in this document applies to any platform.
================================
***Checked for relevance on 31-Mar-2010***
***Checked for relevance on 27-Aug-2014***
***Checked for relevance on 28-Jan-2016***
================================
***Checked for relevance on 24-OCT-2011***
================================


Symptoms

When attempting to upgrade a 4.5.2 TMS instance, the following error occurs while executing tms_dsi_xml_schema.installschemas as described in section 6.2.5 "Configuring DSI Import", from "Oracle Thesaurus Management System - Installation Guide", release 4.6:

ERROR
SQL> exec tms_dsi_xml_schema.installschemas;
BEGIN tms_dsi_xml_schema.installschemas; END;

*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 12
ORA-06512: at "TMS.TMS_DSI_XML_SCHEMA", line 35
ORA-06512: at line 1


Steps To Reproduce:

  1. Perform the steps described in Section 6.2.2, "Upgrading the Master Instance" on page 6-3;
  2. Perform the steps described in Section 6.2.5, "Configuring DSI Import" on page 6-6:
set LOCAL=<databasename>
sqlplus tms/<password>
exec tms_dsi_xml_schema.InstallSchemas;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms