Re: Index troubles with SQLLoader

From: <>
Date: Wed, 26 May 1999 01:37:37 +0200
Message-ID: <7iffhf$glr$>

[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$>...
>Drop and recreate your index before you perform the delete.
Received on Wed May 26 1999 - 01:37:37 CEST

Original text of this message