It takes almost 3 hours to add 20 odd columns to a table of about 8 million records. Each operation Alter Table Add Column takes about 7 minutes, so 20 odd such operations take 3 hours.
A faster way I think of is :
To add columns to table A of 8 million records,
1. create a temporary table B with schema same as table A.
2. copy all data from table A to table B.
3. CLRPFM table A
4. alter table A.
5. copy all data from table B to table A.
But this method seems cumbersome and need to handle foreign keys etc.
Is there any better and faster way to accomplish the task?