Issue with renaming columns?

Toad Data Modeler
1

Sometime TDM does not build the correct renaming alter script.

I’m renaming the columns of some tables. Some tables create a correct alter script:

  1. Create a new table
  2. Filling the table
  3. Renaming this table

Sometime the alter script drops the data, too:

  1. Dropping old colums
  2. Creating new colums

Is there any known issue about this?

Thanks a lot!

2

Hi,

we tried to pick the most dangerous operations for generation of Temorary tables.

In TDM you can define settings for alter script generation. Click Settings | Options and in section Model | Physical Model | Oracle you can find groupbox Alter Scripts Settings with options Use Temporary tables to…

Regards,

Vaclav