Re: How to disable index?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 16 Nov 1999 22:17:43 +0100
Message-ID: <942787126.7668.0.pluto.d4ee154e@news.demon.nl>

No,
to disable an index simply write a select that precludes using the index columns,
like
index_column + 0 = literal

Hth,

--
Sybrand Bakker, Oracle DBA
fumi <fumi_at_tpts5.seed.net.tw> wrote in message news:80sft4$agj$1_at_news.seed.net.tw...
>
> Gennady <gbesfamilny_at_home.com> wrote in message
> news:UqIX3.63311$Rx2.759254_at_news1.rdc1.bc.home.com...
> > Hello,
> > Is it possible to DISABLE and then ENABLE multicolumn index ( without
DROP
> > and CREATE index)?
> >
> > Thanks,
> > Gennady
> >
>
> An index can be disable ONLY if it is a function-based index in Oracle8i.
>
>
>
Received on Tue Nov 16 1999 - 15:17:43 CST