Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> atomicity of trigger replacement

atomicity of trigger replacement

From: <ctcgag_at_hotmail.com>
Date: 26 Feb 2003 20:24:28 GMT
Message-ID: <20030226152428.519$g4@newsreader.com>


Good Evening,

I'd like to replace an existing trigger implementation with a better implementation that is logically identical but gives better performance.

I want to make sure that, during fraction of a second it takes to 'create or replace trigger....', any triggering events will either block until the new trigger is in place or use the old trigger, rather than slipping through the gap. Do I need to take special precautions, or does Oracle automatically ensure this?

Thanks,

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB
Received on Wed Feb 26 2003 - 14:24:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US