topic Re: Oracle Database : Trigger limit in database in Operating System - HP-UX

Oracle Database : Trigger limit in database

malay boy — Thu, 03 Jun 2004 04:58:23 GMT

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

Re: Oracle Database : Trigger limit in database

Eric Antunes — Thu, 03 Jun 2004 05:15:39 GMT

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

Re: Oracle Database : Trigger limit in database

Yogeeraj_1 — Thu, 03 Jun 2004 07:55:49 GMT

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

Re: Oracle Database : Trigger limit in database

twang — Thu, 03 Jun 2004 08:13:29 GMT

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