Re: SQL*Loader and index unusable

Neil Sauerwein <neils_at_ptd.net> wrote in article <34870C7F.758C01BD_at_ptd.net>...
> 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".

ALTER TABLE YOUR_TABLE_NAME DROP PRIMARY KEY; Have a fun,
Serge

> The only way out at this point seems to be to drop the table. Does
> anyone know of a
> way around this?
>
>
Received on Thu Dec 04 1997 - 00:00:00 CST