Re: How many triggers per table?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 25 Nov 1998 17:51:14 GMT
Message-ID: <36604363.16105168@192.86.155.100>

A copy of this was sent to Jos Ndua <josphatn_at_archimedes.nl> (if that email address didn't require changing) On Wed, 25 Nov 1998 18:19:55 +0100, you wrote:

>Folks,
>
>What is the maximum number of triggers per Oracle8 table and are they in
>any way limited to the different events i.e. INSERT, UPDATE, INSTEAD OF
>and DELETE?
>

there is no imposed limit, there are practical limits (its not reasonable to expect 200 triggers to fire on an insert and have excellent performance for example).

>Jos Ndua
>
>josphatn_at_archimedes.nl
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Nov 25 1998 - 11:51:14 CST