Re: Admin Tasks Re-indexing
From: Bolen Coogler <bcoogler_at_dscga.com>
Date: 1996/08/29
Message-ID: <5034t8$tu9_at_main.dscga.com>#1/1
Date: 1996/08/29
Message-ID: <5034t8$tu9_at_main.dscga.com>#1/1
Huijbrechts Rolf <huybrecr_at_realsoftware.be> wrote:
>bwskiles_at_adpc.purdue.edu wrote:
>>
>> it's only a matter of dropping/deleting the index and then recreating it.
> Oracle v7.3 now has a feature to rebuild an index without having the
>creation clause : ALTER INDEX <NAME> REBUILD
Oh, 7.3 will rebuild it all right... in your default tablespace, not the index's originating tablespace, if the two are not the same!
--- Bolen Coogler DBA, BellSouth Information SystemsReceived on Thu Aug 29 1996 - 00:00:00 CEST