Following resolution paths on oracle support pages I determined that I have a corrupted index. But when I try to display or identify that index I get nothing ie no rows.
SELECT tablespace_name, segment_type, owner, segment_name
WHERE file_id = &AFN
and &BL between block_id AND block_id + blocks - 1
That gave me: TS_NAME: CARINATS, SEGMENT_TYPE: INDEX, ...
so it's index right?>
I've inserted my AFN and BL numbers