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

Last updated on APRIL 17, 2023

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