Re: How to disable index?

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Mon, 15 Nov 1999 15:44:29 GMT
Message-ID: <38302A5D.FAE7261F@edcmail.cr.usgs.gov>

It makes no sense to disable an index. If I disable an index, insert rows into the table, and enable the index, then the index does not "know" about the newly added rows. That is why you have to drop the index, insert the rows, and recreate the index.

HTH,
Brian

aquabubble wrote:
>
> In article <UqIX3.63311$Rx2.759254_at_news1.rdc1.bc.home.com>,
> "Gennady" <gbesfamilny_at_home.com> wrote:
> > Hello,
> > Is it possible to DISABLE and then ENABLE multicolumn index ( without
> DROP
> > and CREATE index)?
>
> No, you cannot do this in Oracle... you have to DROP the index and
> CREATE it again. Why do you want to do this? If you supply some more
> information for what you are doing, maybe we can find a better way of
> doing it?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 15 1999 - 09:44:29 CST