RE: SQL*Loader vs External Tables
- From: <Paula_Stankus@xxxxxxxxxxxxxxx>
- To: <thomas.mercadante@xxxxxxxxxxxxxxxxx>, <charlottejanehammond@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Nov 2004 14:38:17 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F
Sent: Wednesday, November 03, 2004 2:12 PM
To: 'charlottejanehammond@xxxxxxxxx'; 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@xxxxxxxxx]
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
---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com/a
--
//www.freelists.org/webpage/oracle-l
--
//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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
