Oracle articles

Here I keep the preferred articles by my readers.

How to change the location of an Oracle external table

In case the underlying file of an external table has changed on the operating system, or you have now a newer version of it with a different extension, I have just found that the table doesn't have to dropped and recreated with a different definition.

The clause ALTER TABLE ... LOCATION is available for external tables;

ALTER TABLE ext_table LOCATION (directory:'file');

For example:


The database release I used is Oracle, the command is still valid in higher versions.