Move columns from one table to another

[gsprince]

Once you copy the data from the original table, you may just want to drop the columns (oracle 8i onwards).

(this way you r not dropping the original table)

Now you can rename the tables, if you need to.