Is there an option for Toad to automatically truncate table names to fit Oracle limitations?
I have a model that was taken from a SQL Server model and most of the table names exceed 30 characters long, I would to know if there is an option for all the table names to be truncated down to 30 characters long, so I can use the generate DDL script.
Toad Data Modeler does not have the ability to truncate table names that exceed 30 characters for the Oracle environment. The reason why this feature does not exist is because there are various methods to truncate or shorten table names for Oracle and each user will want to rename or truncate in their own custom way and Toad cannot accommodate each variation of request, thus there are no plans to implement a truncate table feature in Toad Data Modeler any time soon.
Best practice is to use the Verify Model feature prior to generating a DDL script. There it will display any errors or warnings on the model. Use CTRL + F9 or go to Model | Verify Model, from the main menu. If there are issues with the length, it will display what is causing the warning or error; for example:
Name of Trigger 'A_Seq_Alert Sanctions Instructions_ZZ ID' in Entity 'Alert Distribution Instructions' (for attribute 'AD ID') will exceed 30 characters.