Determine Date of Records Associated With Corrupt Block

From: if_investor_at_yahoo.com <basis_consultant_at_hotmail.com>
Date: Wed, 15 Jun 2011 10:39:26 -0700 (PDT)
Message-ID: <895111cc-c78a-4773-8bbc-adad9b1fb90e_at_s9g2000yqm.googlegroups.com>



Hi,

In a test server we have a corrupt data block in a table that is about 17GB in
size. DBVerify and validate structure both identified the same corrupt block.
(File#f, block #y). Oracle is 10.2.0.4.

That table has a field named DATE, and there is an index on DATE.

Is there a way to use the index in order to identify the date(s) of the data that was on the corrupt block?

For example, suppose that DBVerify and Validate Structure indicate that file#100, block#99999 is corrupt.

Is there a way to check the value of the date field in index TABLEDATE

associated with this file/block?

Thanks,
QZ Received on Wed Jun 15 2011 - 12:39:26 CDT

Original text of this message