My Oracle Support Banner

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 MAY 20, 2019

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***


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:

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;


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.