I want to alter the data type for one column in a big table w/ billions of rows and using range partition. I don't want to lock the table, so I suppose I can only create a new table w/ the new data type for that column and copy the data over and drop the old table. Is this a correct assumption? Also if I want to copy a range partitioned table, what would be the most efficient way to do this? Thanks.