Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*Loader and index unusable
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?
Received on Thu Dec 04 1997 - 00:00:00 CST