Re: Exhaused sequence
- From: Jared Still <jkstill@xxxxxxxxx>
- To: jknight@xxxxxxxxxxxxxx
- Date: Fri, 18 Feb 2005 07:11:30 -0800
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@xxxxxxxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
