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: Re: Index rebuilds

Re: Re: Index rebuilds

From: David Turner <turner_at_tellme.com>
Date: Thu, 5 Oct 2000 11:11:22 -0700
Message-Id: <10640.118633@fatcity.com>


alter index indexname rebuild;

The sql reference or google is a quick way to find this info.

Dave Turner

On Thu, Oct 05, 2000 at 07:52:01AM -0800, cemail_at_sprintmail.com wrote:
>
> I guess my question should have been, can you use alter index
> rebuild or do you have to drop and then recreate the index?
> --- Original Message ---
> "Ruth Gramolini" <rgramolini_at_tax.state.vt.us> Wrote on
> Thu, 05 Oct 2000 05:35:50 -0800
> ------------------
> There was a discussion about this in the past couple of weeks.
> When a table
> is trucated the index is empty . You have to rebuild the index
> after the
> table is poplated.
> HTH,
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, October 04, 2000 9:50 PM
>
>
> >
> > Oracle 8.0.5. Can index rebuilds be used on a table that has
> > been truncated and reloaded? In other words, we have a table
> > and then we truncate it and load it with much of the same data,
> > except more data (don't ask me why they do it this way). Can
> > we have an index, truncate the table, then just do a rebuild?
> > We want to be able to save time with the indexes and also
> be
> > able to change storage parameters.
> >
> > -----
> > Sent using MailStart.com ( http://MailStart.Com/welcome.html
> )
> > The FREE way to access your mailbox via any web browser, anywhere!
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: cemail_at_sprintmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> > San Diego, California -- Public Internet access / Mailing
> Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).
> You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You
> may
> also send the HELP command for other information (like subscribing).
>
>
>
> -----
> Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any web browser, anywhere!
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: cemail_at_sprintmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Oct 05 2000 - 13:11:22 CDT

Original text of this message

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