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: <pankaj_wolfhunter_at_yahoo.co.in>
Date: 28 Feb 2007 04:38:53 -0800
Message-ID: <1172666333.568079.173700@8g2000cwh.googlegroups.com>


On Feb 28, 5:28 pm, "pankaj_wolfhun..._at_yahoo.co.in" <pankaj_wolfhun..._at_yahoo.co.in> wrote:
> 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?- Hide quoted text -
>
> - Show quoted text -

Thanks Maxim.
This solved by problem. Didnt knew the concept properly. Thanks Again. Received on Wed Feb 28 2007 - 06:38:53 CST

Original text of this message

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