Sdo_rdf.remove_duplicates Gets Error ORA-26028: Index RDF_SCHEMA.TSTDEL_UN_IDX Initially In Unusable (Doc ID 1477645.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

Sdo_Rdf.Remove_Duplicates gets error ORA-26028: index RDF_SCHEMA.TSTDEL_UN_IDX initially in unusable state

SQL> exec sdo_rdf.remove_duplicates('tstdela');
BEGIN sdo_rdf.remove_duplicates('tstdela'); END;

*
ERROR at line 1:
ORA-26028: index RDF_SCHEMA.TSTDEL_UN_IDX initially in unusable state
ORA-06512: at "MDSYS.SDO_RDF", line 2642
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms