REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM
REM File:
REM 	c_find_corr_obj.sql
REM
REM <SQLDIR_GRP>MAINT SEGMENT</SQLDIR_GRP>
REM
REM Author:
REM 	Vitaliy Mogilevskiy
REM	VMOGILEV
REM	(vit100gain@earthlink.net)
REM
REM Purpose:
REM	<SQLDIR_TXT>
REM	Finds corrupted object in the datafile
REM	USE when get ORA-1578 error
REM	since it needs block_id and file_id parameters
REM	</SQLDIR_TXT>
REM
REM Usage:
REM	c_find_corr_obj.sql
REM
REM Example:
REM	c_find_corr_obj.sql
REM
REM
REM History:
REM	08-01-1998	VMOGILEV	Created
REM
REM

select segment_name, segment_type
from
dba_extents
where
file_id = &file_id
and &block_id between block_id and block_id + blocks - 1
/