Re: What can be the cause for corrupted index?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 16 Jun 2004 05:34:46 +1000
Message-ID: <40cf4f3d$0$31255$afc38c87@news.optusnet.com.au>

"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message news:40cf2b6c.692042524_at_localhost...
> On 11 Jun 2004 21:58:10 -0700, mvetmp-google_at_yahoo.com (VM) wrote:
>
>
>
> >In addition to DBVERIFY I'd also run "validate structure cascade" plus
> >FULL EXP just to rule out things that DBVERIFY can't handle.
>
>
> Actually, after posting this, I thought given that I run exports
> nightly and haven't had a problem, it would be indicative of 'good'
> data (obviously exports bypass indices).

Indeed it does. If you have a look inside an export dump file with the text editor of your choice, you will see that it "handles" indexes by making sure commands such as "create index pk_emp on emp(empno)" are included in the file.

Regards
HJR Received on Tue Jun 15 2004 - 14:34:46 CDT