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

Home -> Community -> Usenet -> c.d.o.misc -> Does table trigger fire on SQLLoader DIRECT load?

Does table trigger fire on SQLLoader DIRECT load?

From: <kgrigg_at_acxiom.com>
Date: 1997/10/13
Message-ID: <876768513.6557@dejanews.com>#1/1

Hello all!
I am using SQL Loader 8.0 to load a table on an Oracle 8 server. This table has an after insert trigger that put data into 2 other tables based on the values inserted into it. I have had this work successfully using SQL Loader using the 'conventional' method. I tried it using the DIRECT method to try to speed things up, but, it doesn't appear that the trigger fired....can you make it work using the direct method or do I just have to stick with the conventional method?

TIA!! Kelly
kgrigg_at_acxiom.com

ps. Please cc by mail too...our newsfeed is NOT reliable and I have missed messages from it...thanks!

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Mon Oct 13 1997 - 00:00:00 CDT

Original text of this message

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