HPE Community
Operating System - HP-UX
1752795 Members
5901 Online
108789 Solutions
New Discussion юеВ

Oracle Database : Trigger limit in database

 
malay boy
Trusted Contributor

тАО06-02-2004 09:58 PM

тАО06-02-2004 09:58 PM

Oracle Database : Trigger limit in database

Hi,
Does anybody know whether there are limit on how many trigger could reside in the Oracle 8/9 database ?.I'm searching high and low in metalink but could not find any .
Please help

regards
mB
There are three person in my team-Me ,myself and I.
0 Kudos
Reply
3 REPLIES 3
Eric Antunes
Honored Contributor

тАО06-02-2004 10:15 PM

тАО06-02-2004 10:15 PM

Re: Oracle Database : Trigger limit in database

I don├В┬┤t know any kind of limit for the number database triggers... The only limit I see is the storage limit: since each trigger is associated to a table, you must have space in the respective tablespac
Each and every day is a good day to learn.
0 Kudos
Reply
Yogeeraj_1
Honored Contributor

тАО06-03-2004 12:55 AM

тАО06-03-2004 12:55 AM

Re: Oracle Database : Trigger limit in database

Hi,

i don't think that there mights be any limit to the number of triggers that you can create in particular database (8/9).

Likewise for any other database object. However, there might be a limit on the size of the trigger text...

..or the maximum value that the NUMBER datatype can take. (remember OBJ# NOT NULL NUMBER)

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
0 Kudos
Reply
twang
Honored Contributor

тАО06-03-2004 01:13 AM

тАО06-03-2004 01:13 AM

Re: Oracle Database : Trigger limit in database

No, Oracle doesn't have such limit on number of trigger in database.
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.