Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle SQL*Loader Duplicate record handling.
Direct load loads the records directly into data files and does validation
later.
You have to use conventional path when loading for any validation to take
place and for SQL*Loader to reject the record.
Mark
Ming wrote in message <7jj5dk$qq2_at_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 - 09:32:39 CDT