Sequence problem - URGENT!! [message #18744] |
Wed, 13 February 2002 02:20 |
Kjell
Messages: 7 Registered: February 2002
|
Junior Member |
|
|
Hi
I'm having a problem with sequences.
Im callin the sequence in a scipt like this:
select OSCAR_EXP01_SEQ.nextval from dual
When i'm testing everything seems ok, but if i run the script 2-3 hours later it "jumps" ca 19-20 steps.
Ex from 2 to 21.
Anybody out there who can help me with this problem??
|
|
|
Re: Sequence problem - URGENT!! [message #18746 is a reply to message #18744] |
Wed, 13 February 2002 02:39 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
i think u are not using nocache option during the sequence creation.
try...
alter sequence test_seq nocache;
or
create sequence test_seq ..........nocache;
if you are not using nocache or cache option then oracle cache 20sequence. if there is system failure u will lose exactly 20-sequence number
hope it helps!!!
cheers
pratap
|
|
|