Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create trigger and DML
Daud wrote:
> What happen when during the 'create trigger ...' on a table, a DML
> takes place on the table? Does the DML fail or does it wait for the
> 'create trigger' to complete before running?
>
> Thanks
>
> Daud
If there is DML taking place while you are creating a trigger you need to go back to Software 101 and learn about change management concepts.
STARTUP RESTRICT may just be a good idea but it should be the law.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Thu Jan 26 2006 - 15:13:09 CST