Oracle SQL*Loader Duplicate record handling.

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