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 -> INSERT into HUGE table

INSERT into HUGE table

From: Roger Palmen <r.palmen.ani_at_alewijnse.nl>
Date: 2000/08/10
Message-ID: <39927C92.9F93ADE1@alewijnse.nl>#1/1

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

Original text of this message

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