вторник, 26 мая 2015 г.

How to find out corrupt index

ORA-01578: ORACLE data block corrupted (file # 8, block # 22921) ORA-01110: data file 8: '/data/app/oracle/oradata/MYSRVR/datafile/o1_mf_mysrvr_88m82mdj.dbf'

select segment_name,segment_type,tablespace_name, owner 
from sys.dba_extents
where file_id=8 
  and 22921 between block_id and block_id + blocks -1;

Комментариев нет:

Отправить комментарий