Re: SQL*Loader and index unusable

Neil Sauerwein wrote:

> When SQL*Loader encounters a duplicate key it leaves the table's index
> unusable.
> This in and of itself does not seem right to me, but even more confusing
> is that
> the Oracle documentation says to drop the index in this situation; yet
> it won't allow
> the index to be dropped if it is "used for enforcement of a unique or
> primary key".
> The only way out at this point seems to be to drop the table. Does
> anyone know of a
> way around this?

--
Disable the constraint corresponding to the unique/primary key, then load
the data using SQL*Loader, then enable the constarint.

Hope this helps !
(to reply via email, please change "nospam" to "chavali" in my email address
-  :-)  )