Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> INSERT into HUGE table
Hi all,
I'm trying to find the most efficient way to insert large amounts of records (lets say 100K a day) into a single huge table (100M records). However, the problem is that the set of records to insert contains records already in the target table. These duplicate records can either be overwritten or neglected.
A simple but effective INSERT statement fails if only one record doesn't pass the PK-constraint. What is the most efficient way to do this?
Using Oracle 8.1.6 on NT.
Thanks for advice.
Please reply to newsgroup, or pe1pvy_at_amsat.org NOT the sender.
Received on Thu Aug 10 2000 - 00:00:00 CDT