Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What can be the cause for corrupted index?

Re: What can be the cause for corrupted index?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Tue, 15 Jun 2004 17:03:19 GMT
Message-ID: <40cf2b6c.692042524@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). But it wouldn't hurt to run the other commands just be sure.

I'll report when I am done.

Thanks.
.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Jun 15 2004 - 12:03:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US