Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL*Loader and index unusable

SQL*Loader and index unusable

From: Neil Sauerwein <neils_at_ptd.net>
Date: 1997/12/04
Message-ID: <34870C7F.758C01BD@ptd.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US