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:

ALTER TABLE EXT_REFERENCE LOCATION (DIR_REF:'INPUTMOSCOW.476');

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

Home