VIEW: MDSYS.USER_SDO_INDEX_INFO

Source

View Text - Preformatted

select SDO_INDEX_NAME index_name,  table_owner, table_name,
       REPLACE(sdo_column_name, '"') column_name,
       SDO_INDEX_TYPE, SDO_INDEX_TABLE, SDO_INDEX_STATUS
 from user_sdo_index_metadata,
     user_indexes
 where index_name = sdo_index_name

View Text - HTML Formatted

SELECT SDO_INDEX_NAME INDEX_NAME
, TABLE_OWNER
, TABLE_NAME
, REPLACE(SDO_COLUMN_NAME
, '"') COLUMN_NAME
, SDO_INDEX_TYPE
, SDO_INDEX_TABLE
, SDO_INDEX_STATUS
FROM USER_SDO_INDEX_METADATA
, USER_INDEXES
WHERE INDEX_NAME = SDO_INDEX_NAME