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
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
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