RE: Data load options

> From: Jared.Still_at_radisys.com
> 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: PierceED_at_csus.edu

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: ListGuru_at_fatcity.com (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).