Posts

Showing posts from March, 2012

Oracle - Renaming Table Columns in a Oracle External Table

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