increasing the size of a number column
523059Jul 14 2010 — edited Jul 14 2010Hi, we have a need to increate two columns in a table that we have that is fairly large and has about 72 millions rows. I have 2 of the columns in the table that have been created originally as number(3). Well we now need to store a 4 digit number in these columns and I am looking to find out if there are any gotchas for me to look out for if I alter the table and increase the sixe of the two columns to a number(10). Will this have any adverse affect on the data currently stored in the table and is it ok to increase the columns without moving data around?
Thanks in advance.