On Feb 28, 5:04 pm, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> On 28.02.2007 12:16, pankaj_wolfhun..._at_yahoo.co.in 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?
Received on Wed Feb 28 2007 - 06:28:00 CST
