View previous topic :: View next topic
|
Author |
Message |
mailsaurabh.tripathi
New User
Joined: 22 May 2008 Posts: 56 Location: hyderabad
|
|
|
|
i have unloaded a table, droped and recreated it to expand the column length of already existing columns. Now data is to be reloaded and that the data in the expanded columns be reloaded with leading zeros. There are around 80 million rows in the table, so we cannot go for update querry. please suggest a way. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
if the fields to be filled with leading zeroes are numeric, no need to do it
if they are char
unload, reformat the data ( using sort for example ), reload |
|
Back to top |
|
|
|