Recreating a trigger in a 'live' system
From: peter bell <bellpk_at_hotmail.com>
Date: Wed, 25 Jun 2008 11:30:14 +0000
Message-ID: <BAY138-W497F2EFCDE1B881FEAE7B6D3A00@phx.gbl>
Date: Wed, 25 Jun 2008 11:30:14 +0000
Message-ID: <BAY138-W497F2EFCDE1B881FEAE7B6D3A00@phx.gbl>
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/
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 25 2008 - 06:30:14 CDT