Re: Exhaused sequence

Hi Jon,

I may be coming late to this thread, but haven't yet seen the appropriate advice for an exhausted sequence.

It appears that your sequence has been working very hard, perhaps too hard. How long has it been since your sequence has had a vacation?

Perhaps you could transfer it to a USB flash drive and send it on a trip to a warm clime, say Bora Bora. It should be fairly inexpensive, you could probably send it UPS for about $5.00 USD.

A few days lying on the beach, connected to some sleek laptop should do it. After a couple weeks, it would come back fully rested, recharged and feeling like a million.

Oh wait, it already does...

In any case, while your sequence is off in the fun 'n sun, I have a sequence that isn't really busy right now. I could let you use it as a backup while yours is out for $1000.00 USD per week, travel and lodging excluded.

Lemme know,

Jared

On Thu, 17 Feb 2005 15:55:22 -0600, Knight, Jon <jknight_at_concordefs.com> wrote:
> We have a sequence that is about to reach it's maximum value (999999).
> Ordinarly, I would just expand the column and let it keep going, but it
> populates a business column. They don't care what the value is, as long as
> it's unique and no longer than 6 digits. Of course, like many sequence
> populated columns, it's not consecutive.
>
> I'd like to go back and fill in those "gaps" while the business users
> decide what they want to do. So, I'm thinking: reset the sequence to zero &
> create a function that calls nextval until it finds one that's available.
> Besides a performance hit, are there any other gotchas I'm missing?
> Scalability?
>
> Has anyone done something similar before?
>
> Thanks,
> Jon Knight
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l