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

Home -> Community -> Usenet -> c.d.o.server -> Re: Sequences...

Re: Sequences...

From: Paul Baker <paul.baker_at_lvs.co.uk>
Date: Wed, 26 Jan 2000 10:08:06 -0000
Message-ID: <86mh6o$gdk$1@soap.pipex.net>


You can change any of the parameters that define how corresponding sequence numbers are generated; however, you cannot alter a sequence to change the starting number of a sequence. To do this, the sequence must be dropped and re-created.

Michael Rosadino <mrosadino_at_yahoo.com> wrote in message news:IBrj4.490$yM3.44295_at_typhoon.snet.net...
> Does anyone know how to reset a Sequence to its initial "START WITH" value
> [for example 1] without having to drop it and recreate it in DDL??
>
> Thanks in advance,
> =============================
> Michael Rosadino,
> (860)652-0400, x510
> Email: mrosadino_at_med-ecom.com OR
> mrosadino_at_yahoo.com
>
>
>
>
Received on Wed Jan 26 2000 - 04:08:06 CST

Original text of this message

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