Triggers are disabled via ALTER TABLE...DISABLE TRIGGER... or
...DISABLE ALL TRIGGERS. It may well be that the refresh process
issues such statements; reasons to do so might be to speed up the load
process or if data populated by a trigger is already included in the
data being loaded. If this is
Do triggers fire when using direct load?
-Original Message-
Sent: Friday, July 12, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L
Triggers are disabled via ALTER TABLE...DISABLE TRIGGER... or
...DISABLE ALL TRIGGERS. It may well be that the refresh process
issues such statement
Title: RE: Triggers are getting disabled
Ron,
From 9i docs:
Direct Loads, Integrity Constraints, and Triggers
With the conventional path load method, arrays of rows are inserted with standard SQL INSERT statements--integrity constraints and insert triggers are automatically applied. But