My Oracle Support Banner

After Spatial deinstall While Keeping Locator an ORA-04023 error is reported for a table of objects (Doc ID 2517849.1)

Last updated on JANUARY 15, 2020

Applies to:

Oracle Spatial and Graph - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

After deinstalling Oracle Spatial (but keeping Oracle Locator) using Note 1070647.1 and restarting the database (shutdown immediate - startup)
A query on a user defined table that has an SDO_GEOMETRY column fails with:
select * from <TABLE_NAME>;
             *
ERROR at line 1:
ORA-04023: Object select * from <TABLE_NAME>


The custom table is table of objects, where the object definition has an attribute which should have been MDSYS.SDO_GEOMETRY, but now claims to be PUBLIC.SDO_GEOMETRY.

Before Spatial deinstall:

desc <TABLE_NAME>

..
<COLUMN_NAME> MDSYS.SDO_GEOMETRY

After Spatial deinstall:

desc <TABLE_NAME>

..
<COLUMN_NAME> PUBLIC.SDO_GEOMETRY

Cause

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
Symptoms
Cause
Solution
References


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