Changing column data type of a large data warehouse table, what is the quickest way?
Hi,
We are changing a column from integer to varchar for a large data warehouse table. I know that we can add an extra column to save the data, drop and add back the column in question as the varchar data type, and update this column, and then drop the extra column. But this would be way too slow for such large table.
We are thinking to export the table and import it back after recreating the table with the column in varchar, but how to change the data type while exp/imp? Is there a faster way? We don't have enough space to rename the whole table and create a new table, but may have enough space to recreate one partition at a time.
We are changing a column from integer to varchar for a large data warehouse table. I know that we can add an extra column to save the data, drop and add back the column in question as the varchar data type, and update this column, and then drop the extra column. But this would be way too slow for such large table.
We are thinking to export the table and import it back after recreating the table with the column in varchar, but how to change the data type while exp/imp? Is there a faster way? We don't have enough space to rename the whole table and create a new table, but may have enough space to recreate one partition at a time.
0