I upgraded erwin to release 9.8 and when I Forward Engineer schema I am not getting the tables in alphabetical order. That was OK before. What changed and how can I get the Tables to generate their syntax in alphabetical order?
That is specific to Oracle 11g. In older versions of erwin, Oracle 11g was not fully supported. In Oracle 11g there is a new feature called Reference Partitioning. It is a new partitioning option in Oracle 11g that allows the partitioning of two related tables to be based on a referential constraint. In other words, when there is a parent-child relationship between two tables, the parent table can be defined with its reference partitions.
To accommodate that for Oracle 11g, when the tables have a dependency they are generated in the dependency order, otherwise, they are generated in alphabetical order. The workaround is to either delete or uncheck the Generate checkbox for all Relationships. That will essentially suppress all the dependencies and you should then be able to get the tables in alphabetical order.