Hi all,
I need to alter some 50 tables with one column that has integer data type to character because of request from app developers. There is atleast 500000 rows in each of them. After brainstorming, my team put out the plan of exporting, dropping, recreating wiht only the column's datatype changed and then loading the data. I think it wil be a very tedious process and not completable within the give time frame of 10 days.
Is there any other easy way to do this?
Please advise.
Arun
|