Re: managing sequences

Morgan GOARIN wrote:

>Hi
>I am using sequences in a PL/SQL stored procedure and I need to reset my
>sequence. Does anybody know the way to re-initialize an Oracle sequence
>without having to drop and recreate it ?
>Thanks in advance
>Morgan Goarin
>
>

Depends on what you mean by re-initialize. Would cycling solve the problem?

Depends on whether you are on a single user system or whether multiple users might
have different expectations. One user expects a "1" while another expects a different number.

The short answer is no. The long answer is that what you have described above is highly
indicative of a bad design so I'd focus on redesigning it.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)