Home » SQL & PL/SQL » SQL & PL/SQL » Sequence problem - URGENT!!
Sequence problem - URGENT!! [message #18744] Wed, 13 February 2002 02:20 Go to next message
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 Go to previous message
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
Previous Topic: User Authentication by SQL Queries ???
Next Topic: Using Indexes for data access
Goto Forum:
  


Current Time: Fri Mar 29 01:15:33 CDT 2024