Assuming I have the following : create table t1 (x number); create table t2 (y number);create or replace trigger aifer_t1 after insert on t1 for each row begin insert into t2 values (:new.x); end; / And my application frequently executes : insert into t1 values (:some_value); If I recreate the trigger in a 'live' system, is Oracle able to somehow ‘suspend’ inserts on t1 whilst the trigger is being recreated (using breakable parse locks ?) and thereby ensure that all inserts have fired the trigger ? Or is it possible that some inserts into t1 will not fire the trigger during the brief time it was being recreated ?regards peter b _________________________________________________________________ http://clk.atdmt.com/UKM/go/msnnkmgl0010000007ukm/direct/01/