| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Loader vs External Tables
Charlotte,
The biggest benefit that I see is the reduction of one step in a data load process.
Normally, we would load data (using sqlldr) into a staging table, and then use PL/SQL to process that staging table.
With an External table, I can eliminate the first step, and use PL/SQL directly against the external table.
Others might have better observations than this.
Good Luck!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Charlotte Hammond [mailto:charlottejanehammond_at_yahoo.com]
Sent: Wednesday, November 03, 2004 12:09 PM
To: ORACLE-L
Subject: SQL*Loader vs External Tables
Hi All,
I am about to set up a regular data load process. In the past I've done this using SQL*Loader but I'm thinking of inserting from an external table instead. I believe the underlying stuff is much the same but wonder if there were any pros and cons of using external tables over SQL*Loader for regular scheduled loads. It's a pretty straightforward load (not lots of ETL type stuff) of data directly into columns so being able to do it with PL/SQL is a small, but not huge benefit.
Thanks for any comments.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 03 2004 - 13:08:07 CST
 |
 |