|
|
| Re: sequence [message #516299 is a reply to message #516296] |
Sat, 16 July 2011 05:08   |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Well, one answer would be
alter sequence XX_SEQUENCE maxvalue 100;
but I don't think that is really what you want. I don't know what you are actually trying to achieve, but if it is anything to do with getting predictable, repeatable, results then a sequence may not be the correct approach.
Rgds, John.
|
|
|
|
| Re: sequence [message #516316 is a reply to message #516299] |
Sat, 16 July 2011 11:25 |
 |
Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
|
I see that you listed sqlloader where your version belongs. So, I gather that you are trying to load the data using SQL*Loader and want the sequence to start at 1 for each load. So, instead of using a sequence created in SQL, you should use a SQL*Loader sequence. In your control file, just use the keyword sequence instead of using xx_sequence.nextval.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
