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

Home -> Community -> Mailing Lists -> Oracle-L -> Index rebuilds

Index rebuilds

From: <cemail_at_sprintmail.com>
Date: Wed, 4 Oct 2000 17:48:25 -0700
Message-Id: <10639.118547@fatcity.com>


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! Received on Wed Oct 04 2000 - 19:48:25 CDT

Original text of this message

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