RE: Exhaused sequence
- From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
- To: <jknight@xxxxxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 17 Feb 2005 15:22:09 -0800
Could you start using negative numbers in your column, or would that
throw all your applications out of whack?
E.g. alter sequence ... minvalue -999999 ;
-----Original Message-----
Knight, Jon
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
