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;
oracle ora-01578 数据文件XX 损坏 块号XXXXXX
最新推荐文章于 2023-09-20 22:30:31 发布