Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

NNO-00306: server shutdown countdown aborted

1 Answers  


ORA-09263: spini: error initializing process

1 Answers  


ORA-31182: Too many PL/SQL DOM handles specified

1 Answers  


ORA-02087: object locked by another process in same transaction

1 Answers  


ORA-00439: feature not enabled: string

1 Answers  


NCR-03004: NCRO: Unknown message

1 Answers  


ORA-26675: cannot create Streams capture process string

1 Answers  


ORA-01178: file string created before last CREATE CONTROLFILE, cannot recreate

1 Answers  


RMAN-06250: Report of files that need backup due to unrecoverable operations

1 Answers  


EXP-00048: Cannot export SYSAUX Tablespace for Point-in-time Recovery or Transportable Tablespace

1 Answers  


ORA-32116: Buffer size is less than amount specified

1 Answers  


ORA-13620: The task or object string is read-only and cannot be deleted or modified.

1 Answers  


Categories