Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-04096: trigger 'string' has a WHEN clause which is too
large, limit 2K



ORA-04096: trigger 'string' has a WHEN clause which is too large, limit 2K..

Answer / guest

Cause: A trigger's 'when' clause is limited to 2K for
dictionary storage reasons. The trigger being created
exceeded that size.

Action: Use a smaller 'when' clause. Note, the trigger body
could be used to perform the same limiting action as the
'when' clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-38424: no attribute set currently assigned to the expression set

1 Answers  


ORA-01689: syntax error in clause "string" of string

1 Answers  


RMAN-04010: target database Password:

1 Answers  


ORA-38466: user does not have privileges to CREATE/MODIFY expressions

1 Answers  


ORA-24329: invalid character set identifier

1 Answers  






TNS-12589: TNS:connection not bequeathable

1 Answers  


CLSR-00519: No instance found

1 Answers  


ORA-26521: rpc initialization error

1 Answers  


ORA-15047: ASM file name 'string' is not in multiple-file creation form

1 Answers  


AUD-00803: internal error while processing WHERE clause

1 Answers  


SQL*Loader-00414: no columns to load for table string

1 Answers  


DRG-11532: error reading through end of line string for file string

1 Answers  






Categories