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

Comments

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"