Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Beginner question

Beginner question

From: Bob McConnell <bob.mcconnell_at_mci.com>
Date: Wed, 30 Dec 1998 19:49:20 GMT
Message-ID: <368A83A1.7E9AEC22@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 Wed Dec 30 1998 - 13:49:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US