Re: How to disable index?

From: aquabubble <aquabubble_at_geocities.com>
Date: Mon, 15 Nov 1999 11:15:14 GMT
Message-ID: <80oq00$ql0$1@nnrp1.deja.com>

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 - 05:15:14 CST