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>

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-l
Received on Wed Jun 25 2008 - 06:30:14 CDT

Original text of this message