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



Popular posts from this blog

Oracle - duplicate fields in RECORD,TABLE or argument list are not permitted

Oracle - ORA-29282: invalid file ID, ORA-06512: at "SYS.UTL_FILE"