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***
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:
- Perform the steps described in Section 6.2.2, "Upgrading the Master Instance" on page 6-3;
- Perform the steps described in Section 6.2.5, "Configuring DSI Import" on page 6-6:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!