Ashish Karalkar wrote:
Hello All,
I am having a table with 5 columns.
I want to add another column by altering the table at 2nd position
constraint is that I can not drop and recreate the table as column
ordering is of importance.
Is there anyway to do so.
Copy everything into a tmp table, drop the original, recreate it with
the new column in the correct position, and move the data back into it.
brian
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
