Re: Disabling indicies

From: <mark.powell_at_eds.com>
Date: Fri, 15 Jan 1999 14:15:07 GMT
Message-ID: <77nih2$7uk$1@nnrp1.dejanews.com>

In article <369DCA8E.D9227485_at_genedata.com>, Tim Eyres <tim.eyres_at_genedata.com> wrote:
> Hi
>
> Does anybody know if it is possible to disable and index in Oracle, and
> then enable it at a later stage. I don't want to drop the index, only
> delay the construction of the index until I have loaded all the data.
>
> Tim Eyres
>

There is no way to disable an index without dropping it. Drop the index, load the data, and recreate the index. If the index in question exists as part of a primary or unique constraint, disableing the constraint will drop the index.

Mark D. Powell

Mark D. Powell -- The only advice that counts is the advice that you fo

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 15 1999 - 08:15:07 CST