Re: Index troubles with SQLLoader

From: <x_at_x.com>
Date: Wed, 26 May 1999 01:37:37 +0200
Message-ID: <7iffhf$glr$1_at_mars.worldonline.fr>


[Quoted] [Quoted] 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 [Quoted] [Quoted] 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 Wed May 26 1999 - 01:37:37 CEST

Original text of this message