Re: Sequence in SQL-LOADER

On Feb 28, 5:28 pm, "pankaj_wolfhun...@xxxxxxxxxxx"
<pankaj_wolfhun...@xxxxxxxxxxx> wrote:
On Feb 28, 5:04 pm, Robert Klemme <shortcut...@xxxxxxxxxxxxxx> wrote:





On 28.02.2007 12:16, pankaj_wolfhun...@xxxxxxxxxxx wrote:

Greetings,
I am using sequence in sql-loader to insert unique
values in a table.

ctl file (Demo):

LOAD DATA
INFILE 'test.dat'
APPEND
INTO TABLE test_loader
FIELDS TERMINATED BY "|"
OPTIONALLY ENCLOSED BY '"'
(
name char,
loadseq SEQUENCE(MAX,5)
)

I want my value to start from 5 and thereafter get incremented by 1
every time.
But for now its getting incremented by 5?

Is any there any way in sql-loader or any other to achieve this?

DB Version:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production

Help would be appreciated.

You probably fell victim of sequence caching. You could switch off
caching but this is inefficient if you have several concurrent imports.

Regards

robert- Hide quoted text -

- Show quoted text -

Thanks Robert.
We dont have several concurrent imports.
How to switch off from caching?
I mean we have to specify some sequence name in order to alter it to
nocache.
How to implement this with sql-loder sequence?- Hide quoted text -

- Show quoted text -

Thanks Maxim.
This solved by problem. Didnt knew the concept properly.
Thanks Again.

.