| Data loading by sql loader and trigger is not working [message #328476] |
Fri, 20 June 2008 05:29  |
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  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
