After altering a model in Oracle 10g, by adding a new foreign key for a table and creating new indexes, the generated script that comes from these changes is not able to be run into the database because TDM generates the script in the wrong sequence.
The error occurs because the constraint is defined ( alter table ) before the create index.
Issue fixed in Toad Data Modeler 3.1.5. The latest version of Toad Data Modeler can be downloaded at: http://support.quest.com/support_download/Downloads.asp
