|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
Renaming objects in Oracle
.... yet to be finished ....
rename table_1 to table_2
This is equivalent to alter table .. rename to ...
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;