Re: Index troubles with SQLLoader

Ok, I done that for all my indexes that are not on the Primary Key (PK_THIRD).
Nothing is changing.
I guess the trouble is on my Pk_third index but I need drop my PK before (?).
I can't do because I had old data in the THIRD table that have their PK used into others tables : I use SQLLoader in APPEND mode.

Do I always recreate indexes when I load datas with SQLLoader ?

Thanks for help.

Chris Weiss a écrit dans le message <7if2j6$61m$1_at_msunews.cl.msu.edu>...
>Drop and recreate your index before you perform the delete.
>
>Chris
>
>
Received on Tue May 25 1999 - 18:37:37 CDT