Thursday, November 4, 2010

Loading data into an Oracle Database through External Tables

Frequently, I am asked to run a script which has numerous insert statements. These are generated from flat file(s), and their size can be quite large (in the MB's). A useful and practical alternative is using External Tables. These are tables (for all intents and purposes), which use delimited flat...
continue reading "Loading data into an Oracle Database through External Tables"