Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Database : Trigger limit in database

malay boy
Trusted Contributor

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.
3 REPLIES
Eric Antunes
Honored Contributor

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.
Yogeeraj_1
Honored Contributor

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)
twang
Honored Contributor

Re: Oracle Database : Trigger limit in database

No, Oracle doesn't have such limit on number of trigger in database.