Reseting a sequence number to value less than current last_numbe r

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 25 Apr 2003 15:26:59 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7039983C8@lnewton.leeds.lfs.co.uk>

Gents,

there is a way - go to :

http://www.jlcomp.demon.co.uk/faq/resetseq.html

for the gruesome details.

Cheers,
Norm.

PS. Jim, if you drop a sequence any triggers etc that use it go invalid until (a) recompiled manually or (b) recompiled on the fly.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Jim Kennedy [mailto:kennedy-down_with_spammers_at_attbi.com] Posted At: Friday, April 25, 2003 3:19 PM Posted To: server
Conversation: Reseting a sequence number to value less than current last_number
Subject: Re: Reseting a sequence number to value less than current last_number

Why? That is why are you "resetting" the sequence numbers. As far as I know you have to drop and recreate them to have them start over again. Jim Received on Fri Apr 25 2003 - 09:26:59 CDT