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 220.127.116.11 to 18.104.22.168 [Release 11.2]
Information in this document applies to any platform.
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:
After Spatial deinstall:
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