Table conversion

[Former Member]

Hi All,

I have some doubts related to table conversion:

1. The database commits after 16 MB during the table conversion. Can any one explain this concept to me.

2. If we have changed a field length from 60 to 30 character for a key field and then perform the conversion, we will be having case of duplicate fields. What should we do in this regard.

Regards,

Dhiraj

[Rodrigo-Giner]

1- In simple word, the database try to "convert" the DB without deleteing the original, if it cant then pass the DB to memory, delete the original and replace the entire DB. only if there is no error the DB execute commit.

2- u say that u changed a field from 60 char to 30 char, and will have duplicate fields.

If this field isn't a Key Field there should be no problem. Now If this field is Key field and make a duplicate Key entry, will be an error of course bc each entry has to be unique.