RE: Exhaused sequence

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 17 Feb 2005 15:22:09 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F60262119FC95@irvmbxw02>

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.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 17 2005 - 18:25:26 CST