Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sequence in SQL-LOADER
Robert Klemme schrieb:
> On 28.02.2007 12:16, pankaj_wolfhunter_at_yahoo.co.in wrote:>> values in a table.
>> Greetings,
>> I am using sequence in sql-loader to insert unique
> > You probably fell victim of sequence caching. You could switch off > caching but this is inefficient if you have several concurrent imports. > > Regards > > robert
Please, read the manual for utilites you are trying to use. http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96652/ch06.htm#1008321
What you are actually doing is
SEQUENCE(MAX,5) means, you start from the maxvalue available in the
table for this column (plus increment) and increment your sequence by 5.
If you would want to start with 5 and increment by 1, you should write
SEQUENCE(5,1) or simply SEQUENCE(5), because increment by 1 is default.
Best regards
Maxim Received on Wed Feb 28 2007 - 06:22:43 CST