Home » RDBMS Server » Server Utilities » SQL Loader
SQL Loader [message #185111] Mon, 31 July 2006 01:11 Go to next message
Messages: 4
Registered: July 2006
Karma: 0
Junior Member
Hi all,

I have a doubt in SQL Loader.

We have SEQUENCE function in SQL Loader or can create Sequence in Oracle database for generating a number sequence for

a column while loading data using SQL Loader into table or multiple tables.

My requirment is this.

For the first run in SQL Loader, say some 100 records are loaded it has to generate 1 ........ 100 for a column.
For the next run, say some 65 records are loaded it has to generate 1 ...... 65 for the same column. (not as 101 .... 165).

Please help me on this.

Thanks & Regards,

Re: SQL Loader [message #185263 is a reply to message #185111] Mon, 31 July 2006 17:06 Go to previous message
Barbara Boehmer
Messages: 8737
Registered: November 2002
Location: California, USA
Karma: 0
Senior Member
You can either use the SQL*Loader sequence or drop and recreate or reset the SQL sequence before each run. I would use the SQL*Loader sequence.
Previous Topic: wwsec_persons$ problem when restoring full dmp of 817 portal
Next Topic: Loading control file in SQL loader
Goto Forum:

Current Time: Tue Aug 22 13:52:17 CDT 2017

Total time taken to generate the page: 0.01975 seconds