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,
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