Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: atomicity of trigger replacement
ctcgag_at_hotmail.com wrote:
> 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
If the trigger is firing your attempt to compile the new code will hang.
This should be done at 2:00am on Sunday morning unless there is a more convenient downtime.
Daniel Morgan Received on Wed Feb 26 2003 - 15:07:24 CST