--
-- Find out the file id and block id, usually from alert.log
-- or from error message when running sql statement
--
-- Replace F with the file id and B with block id
--
SELECT SEGMENT_NAME, SEGMENT_TYPE, RELATIVE_FNO
FROM DBA_EXTENTS
WHERE FILE_ID = F
AND B BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1
/
|