SQL*Loader ignoring constraints
From: <aharris1_at_my-deja.com>
Date: Tue, 19 Dec 2000 16:54:41 GMT
Message-ID: <91o3sb$3e7$1_at_nnrp1.deja.com>
Date: Tue, 19 Dec 2000 16:54:41 GMT
Message-ID: <91o3sb$3e7$1_at_nnrp1.deja.com>
[Quoted] 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 [Quoted] 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/
Received on Tue Dec 19 2000 - 17:54:41 CET