VIEW: MDSYS.ALL_SDO_INDEX_INFO

Source

View Text - Preformatted

select SDO_INDEX_OWNER, 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 all_sdo_index_metadata,
     all_indexes
 where index_name = sdo_index_name and owner=sdo_index_owner

View Text - HTML Formatted

SELECT SDO_INDEX_OWNER
, 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 ALL_SDO_INDEX_METADATA
, ALL_INDEXES
WHERE INDEX_NAME = SDO_INDEX_NAME
AND OWNER=SDO_INDEX_OWNER