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
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: 8610
Registered: November 2002
Location: California, USA
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: Export Error
Next Topic: SQLLDR Direct=true
Goto Forum:

Current Time: Mon Oct 24 18:52:19 CDT 2016

Total time taken to generate the page: 0.11547 seconds