RE: sqlldr into a table that uses sequences

Thanks Ina. I knew I could generate a sequence on load, but I was hoping to be able to dynamically use the numbers out of the existing sequence. There are two work-arounds I can think of - either reset the existing sequence and use the numbers in the block I've skipped, or generate a sequence outside of the existing sequence.

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: inna z [mailto:innaz_at_lycos.com]
Sent: Wednesday, September 06, 2000 12:17 AM To: Multiple recipients of list ORACLE-L Subject: Re: sqlldr into a table that uses sequences

 in control file add
...
into table table_name
append
(sequence(max,incrment_number),...)

MAX means start with the maximum value currently in this column in the table plus amount of the increment_number. SEQUENCE and MAX are keywords, instead increment_number put any integer number >=1. it has to work.

--

On Tue, 05 Sep 2000 13:44:22  
 David Barbour wrote:


>It's Tuesday, and already I'm a day behind.  How does this happen?  

>

>Anyway, I've got a large number of records to load into a table that

>generates an order number from a sequence when records are added during the

>course of "normal" processing.  I need to obtain these sequence numbers

>during an append using sqlldr.

>

>Any ideas?  

>

>David A. Barbour

>Oracle DBA - ConnectSouth

>512-681-9438

>dbarbour_at_connectsouth.com

>

>-- 

>Author: David Barbour

>  INET: DBarbour_at_connectsouth.com

>

>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).

>



Get your FREE Email and Voicemail at Lycos Communications at
http://comm.lycos.com
-- 
Author: inna z
  INET: innaz_at_lycos.com

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