| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: sqlldr into a table that uses sequences
Then, at the end of the process, alter the sequence and change the next
value based on the max value in the table.
Steve
> -----Original Message-----
> From: inna z [mailto:innaz_at_lycos.com]
> Sent: Wednesday, September 06, 2000 1: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
Received on Wed Sep 06 2000 - 07:38:18 CDT
 |
 |