Re: sqlldr vs referential integrity

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 22 Nov 2001 09:44:17 +0000
Message-ID: <3BFCC8F1.4794_at_yahoo.com>


Goran Sokol wrote:
>
> Hi,
>
> I am using sqlldr on 8.1.6. for AIX for loading data in detail table with
> one enabled foreign key and master table has no data.
> I have successfully loaded data not using directpath in detail table and
> constraint is still enabled.
> I can disable constraint, but when I try to enable it I got error.
> Can sqlldr override referential integrity?
>
> Goran

There are control file commands to disable constraints before loading, but I'm pretty sure that they are only relevant for direct path loading. Conventional load should be subject to normal constraints (presuming they are enabled)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Thu Nov 22 2001 - 10:44:17 CET

Original text of this message