Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Disabling indicies

Re: Disabling indicies

From: Scott Johnson <sjohns6_at_yahoo.com>
Date: Thu, 14 Jan 1999 09:48:52 -0500
Message-ID: <77l06g$qgr$1@birch.prod.itd.earthlink.net>


You'll have to drop the index and re-create. You can speed up the process by using unrecoverable when re-creating the index.

stj

Tim Eyres wrote in message <369DCA8E.D9227485_at_genedata.com>...
>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
Received on Thu Jan 14 1999 - 08:48:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US