iNTERFACEWARE™ Inc.

Character Limit For Oracle Table Names

There is a known character limit for channel names in Iguana, which affects all Oracle databases. Because Iguana automatically generates extra characters when it creates tables, table names are restricted to 10 characters. For example, let's say you had one channel that had To Database as the destination component and LLP Listener as the source component. Iguana would create the following tables, where channel_name is the name of your channel:

• channel_name_dest1_to_dat_err
• channel_name_source1_llp_lis_err (the highest number of characters generated by Iguana during table generation)
• channel_name_cha_suc_log
• log_indices_channel_name.

The highest number of extra characters generated by Iguana is in the second table. Since Iguana generates 20 extra characters for the longest table name and Oracle restricts table names to 30 characters, the character limit is 10. If you do not limit the characters of table names, you will receive an error when you try to export your tables.

	Since the known character limit for tables is 30, table names inside VMD files used by the To Database and From Database channels must be 30 characters or less. Message names inside VMD files used by From Database channels must also be 30 characters or less.