Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RESETTING A SEQUENCE
"SDG" <simong_at_explor.co.uk> wrote in message
news:7psU5.276$4o3.168024_at_newsr1.u-net.net...
> HOW DO YOU RESET A SEQUENCE NUMBER ?
>
> Thanks in anticipation
> SDG
>
>
First of all: please stop using caps.
You can reset a sequence by dropping and recreating it, alter sequence will
not work.
Hth,
Sybrand Bakker, Oracle DBA
Received on Mon Nov 27 2000 - 06:38:29 CST