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: Index Questions

Re: Index Questions

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 15 Jul 2004 04:46:30 GMT
Message-ID: <G_nJc.44791$yd5.40929@twister.nyroc.rr.com>

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:b6beca79.0407140040.2ea8fab8_at_posting.google.com...
> melliott42_at_yahoo.com (Michael) wrote in message news:<91721cf.0407131451.737d98b_at_posting.google.com>...
> > Hello,
> >
> > In Oracle 8i on Solaris how can I:
> >
> > 1. Determine the SQL used to create an existing index?
>
> Either
>
> 1. Query user_ind_columns and user_indexes for the relevant attributes
> and then use sql to write the sql or
>
> 2. export with the indexfile parameter.
>
> > 2. Rebuild an Index that may be corrupt or have
> > invalid data?
>
> ALTER INDEX .... REBUILD. you can use this to move indexes as well.
--snip--

hmmm ... if an index is corrupt or has invalid data ... and one uses alter index rebuild ... won't that command use the index itself to (re)build. In that case, the rebuilt index will have the same corruption / invalid data.

Isn't the correct/safer way be to recreate (drop - create) the index?

Anurag Received on Wed Jul 14 2004 - 23:46:30 CDT

Original text of this message

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