Re: Oracle sequence problem

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 26 Oct 1999 14:02:05 -0400
Message-ID: <7v6ogc$7j9$1@autumn.news.rcn.net>

I just checked my Oracle SQL Reference (Version 7.0 Developer's Release) and it says that the only way to change the sequence is to drop and then recreate the sequence. This leads me to suspect that your application is recreating the sequence every time it is kicked off.

hth
jerry gitomer

ivoly_at_my-deja.com wrote in message
<7v33v5$5lk$1_at_nnrp1.deja.com>...
>Hi there
>
>I need to solve a problem with Oracle sequence-trigger (for
generating
>an "next" value). For empty table everything works fine, but
when you
>are about to issue "insert" statement for a table with
previously loaded
>data in it (say from a .dat file), the next value goes to 1,
instead to
>the next largest in the column. E.G.You have a table with a
column that
>has 10 records from 1 to 10. When you execute
insertinto.....values...
>it creates as a next value 1 instead of 11, next 2 instead of 12
and so
>on.
>
>Any suggestions?
>
>Thanx
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Oct 26 1999 - 13:02:05 CDT