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 -> Oracle SQL*Loader Duplicate record handling.

Oracle SQL*Loader Duplicate record handling.

From: Ming <fungs_at_logica.com>
Date: Tue, 8 Jun 1999 14:21:50 +0100
Message-ID: <7jj5dk$qq2@romeo.logica.co.uk>


Dear all

I'm currently using direct loader to load a large datafile into a fact table with primary key and foreign key constraints. However whilst SQL*Loader recognises that primary key constraints have been violated with dupicate records it carries on loading them.

Thus causing the primary key to go into a unstable state.

Is there a way to trap these duplicate records within direct SQL*Loader or a t least terminate the loader so as not to load the file. Received on Tue Jun 08 1999 - 08:21:50 CDT

Original text of this message

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