Re: dba_extents

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 11 Feb 2004 11:22:48 +0100
Message-ID: <402a01f7$0$28152$626a14ce@news.free.fr>

"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