Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Table conversion

Former Member

‎2007 Aug 29 1:54 PM

0 Likes
285

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

1 REPLY 1
Read only

Rodrigo-Giner
Active Contributor

‎2007 Aug 29 2:15 PM

0 Likes
262

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.