Data loading by sql loader and trigger is not working [message #328476] |
Fri, 20 June 2008 05:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
MIFI
Messages: 256 Registered: February 2008 Location: U.K.
|
Senior Member |
|
|
Hi,
I am working on oracle 10g r2 on linux, i am loading data in table1 by using sql loader and want that whenever there is a loading of record in table1 the insert trigger must fire and insert or update record in table 2. but whenever i load data, first triggers are disabled and reenabled. but there is no change in table2 when i am loading data in table1
|
|
|
|
|
Re: Data loading by sql loader and trigger is not working [message #328497 is a reply to message #328490] |
Fri, 20 June 2008 06:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Database Utilities
Chapter 11 11 Conventional and Direct Path Loads
Section Direct Loads, Integrity Constraints, and Triggers
Quote: | Table insert triggers are also disabled when a direct path load begins. After the rows are loaded and indexes rebuilt, any triggers that were disabled are automatically reenabled. The log file lists all triggers that were disabled for the load. There should not be any errors reenabling triggers.
|
Regards
Michel
|
|
|