Recreating a trigger in a 'live' system
- From: peter bell <bellpk@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Jun 2008 11:30:14 +0000
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/
Other related posts:
