Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Sequence in SQL-LOADER

Re: Sequence in SQL-LOADER

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Wed, 28 Feb 2007 13:04:08 +0100
Message-ID: <54l9d6F2122toU1@mid.individual.net>


On 28.02.2007 12:16, pankaj_wolfhunter_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 Received on Wed Feb 28 2007 - 06:04:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US