Hello All,
I have problem with indexes on Spatial 12c.
On my DB I have partitioned table with domain index called 'IO_SHAPE_IDX, on Spatil SHAPE column.
All index partitions are valid.
When I try to truncate one of the partitions, error occurs:
ALTER TABLE XXXX TRUNCATE partition (P_113863)
Error report -
SQL Error: ORA-29859: error occurred in the execution of ODCIINDEXTRUNCATE routine
ORA-13209: internal error while reading SDO_INDEX_METADATA table
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 43
29859. 00000 - "error occurred in the execution of ODCIINDEXTRUNCATE routine"
*Cause: Failed to successfully execute the ODCIIndexTruncate routine.
*Action: Check to see if the routine has been coded correctly.
and then index for this partition have state = USABE, but domidx_opstatus = FAILED.
select * from user_ind_partitions where index_name = 'IO_SHAPE_IDX' and domidx_opstatus != 'VALID';
I try to rebuild index, but it don't work:
ALTER INDEX IO_SHAPE_IDX REBUILD PARTITION P_113863
Error report -
SQL Error: ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1, Check Oracle Error <13209>
ORA-13209: internal error while reading SDO_INDEX_METADATA table
29874. 00000 - "warning in the execution of ODCIINDEXALTER routine"
*Cause: A waring was returned from the ODCIIndexAlter routine.
*Action: Check to see if the routine has been coded correctly
Check the user defined warning log tables for greater details.
Any ideas?