Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Loader Question: DIRECT LOAD option

SQL Loader Question: DIRECT LOAD option

From: <kiran_mamidi_at_my-deja.com>
Date: 2000/06/16
Message-ID: <8idudc$5pb$1@nnrp1.deja.com>#1/1

Hi guys,
I am trying to use DIRECT LOAD method using SQL loader (DIRECT=TRUE option). Direct load disables the referential integrity constraints while loading data. It can reenable the referential constraints after loading the data if I keep a key word REENABLE in the control file.

I could not figure where to put REENABLE option in the control file. If some one could help me with the REENABLE option with example, I would gratly appreciate that.

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 16 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US