Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP ! : sequence nextval

Re: HELP ! : sequence nextval

From: Ubiquitous <weberm_at_polaris.net>
Date: Sun, 11 May 2003 18:29:08 -0500
Message-ID: <mOmdnXge_t1ZQSOjXTWcow@comcast.com>


In article <b7me0b$fpr$1_at_charm.magnus.acs.ohio-state.edu>, casey.34_at_osu.edu wrote:

>I rebuilt a server & reinstalled the DB & many of the sequences were renewed
>back to thier initial value (1). I need to get them back up to the values
>they need to be.

I don't know the exact sytax, but when you declare the sequence, you can specify a starting value. Please consult the documentation.

-- 
======================================================================
ISLAM: Winning the hearts and minds of the world, one bomb at a time.
Received on Sun May 11 2003 - 18:29:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US