RE: Re: Oracle XE Corruption
- From: "Daniel Fink" <daniel.fink@xxxxxxxxxxxxxx>
- To: jkstill@xxxxxxxxx, jepettrey@xxxxxxxxx
- Date: Wed, 25 Aug 2010 16:59:46 +0000
I'm a little bothered by the fact that a known corrupt index would be used to
rebuild itself. I would expect
1) The rebuild to fail
2) The rebuild to use the table data as the source
One question in my mind is what was the index state? Was it still marked as
good in the data dictionary despite these errors? Should it not have been
marked as corrupt/unusable?
------- Original Message -------
On 8/25/2010 4:52 PM Jared Still wrote:
On Wed, Aug 25, 2010 at 9:22 AM, Evan Pettrey <jepettrey@xxxxxxxxx> wrote:
The rebuild did work, but the errors still remained and the log continued
to grow. After dropping and recreating the indexes everything worked
properly.
This would seem to validate the statement in the docs that 'REBUILD' does
read the old index rather than table data.
Someone care to test this?
Win worldwide fame and glory by verifying that the docs are actually
correct. :)
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
