Re: dba_extents

From: Ron <support_at_dbainfopower.com>
Date: Wed, 11 Feb 2004 01:57:07 -0800
Message-ID: <18idnSEtCPtgZ7TdRVn-uw@comcast.com>

Hello hope,

Check dba_free_space as well.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"utkanbir" <hopehope_123_at_yahoo.com> wrote in message 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
Received on Wed Feb 11 2004 - 03:57:07 CST