Saturday, 18 June 2011

finding block corruption table

SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id = 1
and 1434 between block_id AND block_id + blocks - 1;

output of query

tablespace_name=system
segment_type=table
owner=sys
segment_name=job$

No comments:

Post a Comment