NM.Mathan Oracle Apps DBA
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment