Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sequences...
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
![]() |
![]() |