imdinst.sql=ORA=29809, deinssdo.sql=ORA-2303, drop user MDSYS=ORA-600[15264] (Doc ID 278623.1)

Last updated on JUNE 26, 2012

Applies to:

Oracle Spatial - Version 10.1.0.2 to 10.2.0.5 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 31-Mar-2012***


Symptoms

While running imdinst.sql to remove Oracle interMedia, the following error is returned:

     drop operator mdsys.locator_within_distance
     *
     ERROR at line 1:
     ORA-29809: cannot drop an operator with dependent objects

If trying to deinstall just Oracle Spatial, these errors are returned:

     SQL> @deinssdo.sql
     drop type MDSYS.SDO_GEOMETRY
     *
     ERROR at line 1:
     ORA-02303: cannot drop or replace a type with type or table dependents


     drop type MDSYS.SDO_ELEM_INFO_ARRAY
     *
     ERROR at line 1:
     ORA-02303: cannot drop or replace a type with type or table dependents


If trying to drop the MDSYS user, an ORA-600[15264] error is returned:

     SQL> drop user mdsys cascade;
     drop user mdsys cascade
     *
     ERROR at line 1:
     ORA-00600: internal error code, arguments: [15264], [], [], [], [], [], [], []


A SQL trace shows:

     *** 2004-07-13 11:18:05.383
     ksedmp: internal or fatal error
     ORA-00600: internal error code, arguments: [15264], [], [], [], [], [], [], []
     Current SQL statement for this session:
     drop table "MDSYS"."SDO_GEOR_SYSDATA_TABLE" cascade constraints purge force
     ----- Call Stack Trace -----
     kkdllk0, kkdldid, kkdldai, dtbdrp

Any combination of these tries:

     conn mdsys
     drop table sdo_geor_sysdata_table;
     drop table sdo_geor_sysdata_table purge force;
     drop table sdo_geor_sysdata_table cascade constraints;
     drop table sdo_geor_sysdata_table purge;
     drop table sdo_geor_sysdata_table purge force;

results in the same error:

     ERROR at line 1:
     ORA-00600: internal error code, arguments: [15264], [], [], [], [], [], [], []

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