Re: how to rebuild index after direct path load?

From: dave mausner <dmausner_at_ameritech.net>
Date: Thu, 25 Nov 1999 00:59:41 GMT
Message-ID: <h30%3.535$pz4.7116@nntp0.chicago.il.ameritech.net>

In article <81hbld$6nu$1_at_nnrp1.deja.com>, hkpang_at_my-deja.com wrote:
>I need to upload a huge dataset into an existing table. If the dataset
>contains duplicate keys, I want to the delete the old ones already in
>the table.
>
>
>2) drop the index before upload, reenable the index with exceptions
>going to an exception table. the probelm is that both the old rows and
>the new rows are in the table, there is no way I can figure out which
>one to eliminate.

disable constraints/drop indexes. there's your suggestion.

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago. Received on Wed Nov 24 1999 - 18:59:41 CST