in 9i, you can do that
quote:

最初由 coolyl 发布
alter table table_name rename column XXX to XXX

otherwise , you must:
1: recreate table
2: modify the sys.col$
3: in 8i you can add a column then drop a column
alter table tablename add (col1 number)
alter table tablename drop ( col2 number);

the best way is :
create table () as select ... from ......