RE: VLDB, Sequence and Sql*loader

Check sql*loader documentation:  

sequence ::=

column_name SEQUENCE ( {COUNT | MAX | integer} [, incr]  

Regards,  

Waleed

-----Original Message-----
Sent: Wednesday, May 21, 2003 6:47 AM
To: Multiple recipients of list ORACLE-L

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: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.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).