Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> atomicity of trigger replacement
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 50GBReceived on Wed Feb 26 2003 - 14:24:28 CST
![]() |
![]() |