Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Beginner question
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
![]() |
![]() |