René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Renaming objects in Oracle

.... yet to be finished ....

Renaming Tables

rename table_1 to table_2
This is equivalent to alter table .. rename to ...

Renaming Columns

A column can only be renamed with Oracle 9i onwards.
In 8i, the following solution is proposed:
rename some_table to some_table_;

create view some_table 
as 
select col_1 col_1_new_name, col_2, col_3, col_n from some_table;