> From: [EMAIL PROTECTED]
> Date: Wed, 25 Jul 2001 08:25:06 -0700
> Subject: RE: Data load options
>
> I will second Lisa's recommendations.
>
> If you have much data, and/or will be doing this frequently,
> SQL*Loader is your friend. It is very fast.
>
> Loading from a SQL script is very bad unless you have small
> amounts of data.
>
> I once worked with a duhveloper who could not be dissuaded from
> loading all data from SQL scripts.
Why did the duhveloper do this? Was the data load simple, or complex?
The only time I do SQL script inserts is when there is a very small
"one time" data file that has to be loaded for some adhoc report, and
I'm too lazy to edit a loader ".ctl" file with the positionals
knowing that is is "throw away".
For anyone that has never done it: using editor macros, you can put a
large amount of duplicate SQLplus "insert into" text into the script
in front of the data. You can also use editor macros to put all the
quotes/commas if the data is column positioned.
SOOOOOOOOOOO MUCH FUUUUUUUUUUUN AND MADNESS !!!!!!!!!!!!!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
