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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rebuild index

RE: Rebuild index

From: Deshpande, Kirti <Kirti.Deshpande_at_gtedc.gte.com>
Date: Tue, 2 May 2000 11:25:52 -0500
Message-Id: <10485.104694@fatcity.com>


You can generate an index build script dynamically from dba_ind_columns (or user_ind_columns) view...
OR if this is an Oracle8i database and there is enough room in the index tablespace, you may just issue the rebuild index command. - Kirti  

> -----Original Message-----
> From: Connie Milliken [SMTP:cemail_at_sprintmail.com]
> Sent: Tuesday, May 02, 2000 11:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Rebuild index
>
> I am at a site right now where I don't have any documentation. How do
> you rebuild an index?
>
> Thanks.
Received on Tue May 02 2000 - 11:25:52 CDT

Original text of this message

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