Re: reset a sequence in a trigger

From: Werner Hofmann <superomega_at_t-online.de>
Date: Fri, 20 May 2005 01:35:56 +0200
Message-ID: <d6j7so$u3r$02$1@news.t-online.com>

>
> Stupid question maybe but why reset it? A sequence is a large number.
> Are you try to save numbers? You can set a max value and then cycle
> it. Resetting a sequence just seems like you're going about solving
> the wrong problem.
>
> Thanks,
>
> Lewis
>

In this table I have a lot of transactions, and it can be, that the ID which is the primary key can overrun after some time (some years). I can not use another primary key, because this would be with a VARCHAR2 column. And so I wantet to be save, that the oldest entry have the smallest ID for sorting.

Werner Received on Thu May 19 2005 - 18:35:56 CDT