SELECT Tablespace_Name, Segment_Type, Owner, Segment_Name
FROM Dba_Extents
WHERE File_Id = 2 AND
34771 BETWEEN Block_Id AND Block_Id + Blocks - 1
SELECT SEGMENT_NAME,SEGMENT_TYPE,TABLESPACE_NAME FROM dba_Segments WHERE segment_name = 'I_WRI$_OPTSTAT_HH_ST';
SELECT index_name,table_type,table_name,table_owner FROM dba_Indexes WHERE index_name = 'I_WRI$_OPTSTAT_HH_ST'
alter index I_WRI$_OPTSTAT_HH_ST rebuild nologging;