DBA_INDEXES has Spatial Indexes DOMIDX_STATUS=IDXTYPE_INVLD , ALL_SDO_INDEX_METADATA & ALL_SDO_INDEX_INFO view, SDO_INDEX_STATUS=VALID for these same indexes
(Doc ID 2730208.1)
Last updated on JUNE 30, 2022
Applies to:Oracle Spatial and Graph - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.0 version, Installation and Upgrade issues
dba_registry shows SDO as LOADING and DBA_INDEXES has spatial indexes DOMIDX_STATUS=IDXTYPE_INVLD
Upgraded our prod database to 188.8.131.52.0 from 19.3 All spatial indexes created prior to upgrade as STATUS='INVALID' in the DBA_OBJECTS view, and in the DBA_INDEXES STATUS='VALID' and DOMIDX_STATUS='IDXTYP_INVLD'. In the ALL_SDO_INDEX_METADATA & ALL_SDO_INDEX_INFO view, SDO_INDEX_STATUS=VALID for these same indexes, Can run spatial queries for these tables so it looks like spaital indexes are valid. In the DBA_REGISTRY, comp_id SDO has a status='LOADING' and modified ='17-OCT-2020'. Need to validate the invalid part of the spatial index.
SDO has a status='LOADING'
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