Oracle - Renaming Table Columns in a Oracle External Table

March 20, 2012

Unfortunately it is not possible to rename a Oracle external table, the solution is to drop the column and create it from scratch:

alter table
drop column
alter table
add