iNTERFACEWARE Products Manual > Installing and Using Iguana > Using Older Versions of Iguana > Character Limit For Oracle Table Names |
|
Looking for Iguana v.5 or v.6? Learn More or see the Help Center.
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:
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.
|