Re: Beginner question

From: Wasim Hamwi <whamwi_at_bright.net>
Date: Sat, 2 Jan 1999 23:31:07 -0800
Message-ID: <76mrnv$i73$1@cletus.bright.net>

What do you mean by say, existing records fails? do you mean that your sqlldr is not working. Please remember that you need to add the word append to your control file when loading new rows to the existing table with rows.

let me know.

Wassim

Bob McConnell wrote in message <368A83A1.7E9AEC22_at_mci.com>...
>I have a large table containg about 1.5M records which I need to update
>daily with several thousand records.
>The table only unique fields are: field1 char(8) not null, field 2
>char(8), field3 char(8).
>I would like to add any new record or replace any existing record.
>Currently I'm using SQLLDR to add the new records and the existing
>records fail due to constraint.
>Any suggestions are welcome.
>Thanks
>Bob
>bob.mcconnell_at_mci.com
>
Received on Sun Jan 03 1999 - 01:31:07 CST