Re: HELP ! : sequence nextval

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Mon, 12 May 2003 02:08:55 GMT
Message-ID: <3EBF00E8.C8AC0995@telusplanet.net>

Ubiquitous wrote:

> 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.

Try the following

Start at Oracle's document library

(http://docs.oracle.com)
> Oracle9i Database Release 2

(http://otn.oracle.com/documentation/oracle9i.html)
> Oracle9i Database Documentation Viewable CD Release 2 (9.2.0.2.0)

(view = http://otn.oracle.com/pls/db92/db92.homepage)
> Browse the list of books, including PDF for printing

(http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage)
> SQL Reference

(http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/toc.htm)

> CREATE SEQUENCE

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_615a.htm#2067095

> START WITH
This might help your situation. Received on Sun May 11 2003 - 21:08:55 CDT