| 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
I don't think you can index the external table the way you can the
temporary table - that would be a disadvantage of the external table
depending on what you are doing. =20
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F
Sent: Wednesday, November 03, 2004 2:12 PM
To: 'charlottejanehammond_at_yahoo.com'; ORACLE-L
Subject: 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,
=20
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.
=20
Thanks for any comments.
=20
- Charlotte
=09
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l BEGIN-ANTISPAM-VOTING-LINKS ------------------------------------------------------ NOTE: This message was auto-learned as non-spam. If this is wrong, please correct the training as soon as possible. Teach CanIt if this mail (ID 14723760) is spam: Spam: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D14723760&m=3D5bf5= d5899 255 Not spam: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D14723760&m=3D5bf5= d5899 255 Forget vote: https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D14723760&m=3D5bf5= d5899 255 ------------------------------------------------------ END-ANTISPAM-VOTING-LINKS -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 03 2004 - 13:34:09 CST
 |
 |