Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    45

    Unanswered: Block curruption

    Hi all,
    This is regarding to block corruption.
    Please give me an example.

    SELECT tablespace_name, segment_type, owner, segment_name
    FROM dba_extents
    WHERE file_id = <AFN>
    and <BL> between block_id AND block_id + blocks - 1



    Regards
    sudheer

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    Here is an example using file id 5 and block 37 on my system

    Code:
    SQL> column tablespace_name format a15
    SQL> column owner format a10
    SQL> column segment_name format a20
    SQL> SELECT tablespace_name, segment_type, owner, segment_name
      2  FROM dba_extents
      3  WHERE file_id = 5
      4  and 37 between block_id AND block_id + blocks - 1;
    Code:
    TABLESPACE_NAME SEGMENT_TYPE       OWNER      SEGMENT_NAME                      
    --------------- ------------------ ---------- --------------------              
    EXAMPLE          TABLE             HR         LOCATIONS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •