Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Does table trigger fire on SQLLoader DIRECT load?
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 UsenetReceived on Mon Oct 13 1997 - 00:00:00 CDT
![]() |
![]() |