Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> dba_extents

dba_extents

From: utkanbir <hopehope_123_at_yahoo.com>
Date: 11 Feb 2004 01:03:37 -0800
Message-ID: <f6c90ebe.0402110103.6a618c@posting.google.com> 





Hi ,



I have some corruption messages related to blocks. I have checked the
dba_extents in order to find the extents of these blocks , but
unfortunately these blocks dont belong to any extent. How could this
be possible?



This is the query that i run:


select * from dba_extents where file_id=5 and corrupt_block_number
between block_id and block_id+blocks+1



Kind Regards,


hope
Received on Wed Feb 11 2004 - 03:03:37 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US