Re: SQL*Loader ignoring constraints

[Quoted] In article <91o3sb$3e7$1_at_nnrp1.deja.com>,   aharris1_at_my-deja.com wrote:
> When I load a table with foreign key constraints and a before insert
> trigger with SQL*Loader, my foreign key constraints are ignored. The
> end result is a detail table that contains invalid rows (where some
> column values do not exist in the master table). If I drop the trigger
> and just load with SQL*Loader, the foreign key constraints are
> recognized. Any ideas why this is happening? The trigger simply
> populates the last updated date and user columns.
>
> Sent via Deja.com
> http://www.deja.com/
>

[Quoted] Display the control file, a row or two of sample data, and the corresponding rows of the table with the invalid foreign keys. If you have stated the problem and evidence correctly, this is of course impossible. Something in your processing is incorrect.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/