Oracle-L: Re: VLDB, Sequence and Sql*loader

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Wed, 21 May 2003 03:42:03 -0800
Message-ID: <F001.0059EA85.20030521034203@fatcity.com>

VLDB, Sequence and Sql*loader1) Direct mode means that you can not use sql functions so you can not generate id in direct mode. 2) Updating the rows after the load means double the load. Read the raw data and write to the table and then again read and write all the rows.

The simple way is to write a function that return the sequence value and putting a line like: id number "newid()"

Yechiel Adar
Mehish

Original Message ----- From: NGUYEN Philippe (Cetelem) To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 21, 2003 12:46 PM Subject: VLDB, Sequence and Sql*loader

Hi Gurus !
What are the best practises for inserting rows with sql*loader and generating an id for each row (eg: flat file contains 3 column, and destination table contains 4 )

Is-it possible to generate sequence during the loading ? does it work with direct mode ?
Should we use sequence ? or is it better to update each row with a number afterwards?

TIA
Philippe

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Yechiel Adar
INET: adar76_at_inter.net.il

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 21 2003 - 06:42:03 CDT