Error in Trigger Generation in Oracle

When creating new tables limit the name of the table to 29 characters (rather than the Oracle limit of 32 characters).


The reason for this is that the automatic trigger generator for Audits and Last update fields uses the table name plus “_LU” and “_AA” AFTER the table name, and as oracle only allows object names of 32 chars triggers cannot be created where the tablename > 29 chars


Comments

Author: Varun Sharma16 Sep 2008 Member Level: Gold   Points : 2

nice information.
very useful to me..



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: