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,
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
: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