Re: What can be the cause for corrupted index?

"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.