Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Disabling indicies
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