Oracle-L: quickest method

From: Carol Legros <carol_legros_at_hotmail.com>
Date: Wed, 14 May 2003 13:57:16 -0800
Message-ID: <F001.00598E54.20030514135716@fatcity.com>

I'm curious to know whether anyone out there has seen a comparison discussing the pros and cons and/or results of any simulation tests that compare the speed with which data can be loaded into a target database from a source (database or flat file) using the following 3 methods :

(i) Export (from source), Import (to target)
(ii) SQL*Loader (to target)
(iii) SQL or PL/SQL commands (insert to target)

      using a Database Link between source &
      target

I'm working on a data loading strategy and since there are "many ways to skin a cat", I'm considering these as options. Of course, there are other criteria that impact the method chosen, but assuming all things are equal
(ie network bandwidth is good, access to both source and target are not an
issue etc.), which of these methods would be quickest ?

Thanks,
Carol

Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carol Legros
  INET: carol_legros_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Wed May 14 2003 - 16:57:16 CDT