Re: Temporary Index Disable

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Sun, 23 Feb 2003 16:15:33 -0800
Message-ID: <3E596424.C466A8CD@exesolutions.com>

Randy Harris wrote:

> What is the best method to temporarily disable indexes to perform a bulk
> data load? The 8i documentation shows a Disable, but I can't find any
> syntax that works. Should I just go ahead and drop the indexes then
> recreate them?
>
> --
> Randy Harris

Indexes can not be disabled: Only dropped and recreated unless those indexes are associated with a constraint.

How large is the data load?

Daniel Morgan Received on Sun Feb 23 2003 - 18:15:33 CST