Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sequence in SQL-LOADER
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