3:54:31 sys@ORA9> desc t
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME2 VARCHAR2(200)
23:54:32 sys@ORA9> alter table t rename column name2 to name;
Table altered.
Elapsed: 00:00:00.02
23:54:41 sys@ORA9> desc t
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME VARCHAR2(200)