Reset sequence curret # to the beginning

2002-03-01 Thread Rick_Cale
Hi DBAs, Without creating the sequence, is their a way to reset the current seqence # back to 1? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

Re: Reset sequence curret # to the beginning

2002-03-01 Thread Bunyamin K. Karadeniz
Rick , change the sequence to cycle and set max number = next number then take number once it will return to 1 . then move cycle and max . This will help you . Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 01, 2002 3:38 PM

Re: Reset sequence curret # to the beginning

2002-03-01 Thread Jared . Still
:Reset sequence curret # to the beginning Hi DBAs, Without creating the sequence, is their a way to reset the current seqence # back to 1? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858