Posts Tagged ‘ external tables ’

The Core Performance Fundamentals Of Oracle Data Warehousing – Data Loading

April 23, 2010
By

Getting flat file data into your Oracle data warehouse is likely a daily (or more possibly frequent) task, but it certainly does not have to be a difficult one.  Bulk loading data rates are governed by the following operations and hardware resources: How fast can the data be read How fast can data be...

Read more »

Preprocessor For External Tables

November 19, 2008
By

Before External Tables existed in the Oracle database, loading from flat files was done via SQL*Loader. One option that some used was to have a compressed text file and load it with SQL*Loader via a named pipe. This allowed one not to have to extract the file, which could be several times the size...

Read more »