Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dba_extents
"utkanbir" <hopehope_123_at_yahoo.com> a écrit dans le message de
news:f6c90ebe.0402110103.6a618c_at_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
What is your Oracle version?
When do you get the corruption message?
Imho, if a corruption occured if a free block then it doesn't matter as the block will be reformatted when it'll be used.
Regards
Michel Cadot
Received on Wed Feb 11 2004 - 04:22:48 CST