Posted by MGFoster on 07/06/06 20:46

rdraider wrote:
> I created and successfully tested a trigger on a test database. Now that I
> want to put this on a production system, the create trigger statement takes
> way too long to complete. I cancelled after a few minutes. The test
> trigger took just a second to create. The test and production databases are
> identical in design. Only difference is that there are users in the
> production system.

When someone is accessing the target table you can't add anything to it
(indexes, triggers, constraints, etc.). Best to add the trigger during
off-hours.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

[Back to original message]