My Oracle Support Banner

ORA-29874: Warning In The Execution Of ODCIINDEXALTER Routine On Alter Spatial Index (Doc ID 2712652.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Spatial and Graph - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Following error ORA-29874: warning in the execution of ODCIINDEXALTER routine is reported when an spatial index is altered using below command:

SQL> alter index HR.HR_LOCATIONS_SPT rebuild parameters ('MDRT_389E1$ sdo_indx_dims=2 sdo_rtr_pctfree=10 tablespace=APPS_TS_TX_IDX');
alter index HR.HR_LOCATIONS_SPT rebuild parameters ('MDRT_389E1$ sdo_indx_dims=2 sdo_rtr_pctfree=10 tablespace=APPS_TS_TX_IDX')
*
ERROR at line 1:
ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1, Check Oracle Error

Changes

 

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
Changes
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.