Re: Urgent - Help ....

(Since this is "urgent", I'm probably a few days late.) But for future reference...

I assume that "no change in the software" means no changing variables and such that can currently handle only a 9 digit number...

Can your application can handle negative numbers? Is this really a surrogate key?

If so you are in luck! Drop and recreate the sequence with:

    create sequence MY_SEQ increment by -1 start with 0 ... (Add whatever else is appropriate - cache 100, etc.)

Don Granaman
OraSaurus

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, February 20, 2003 2:58 AM

> Hi Gurus,
>
> I need a urgent help.
>
> I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a
> sequence. [ The column name is USERNO ]
>
> This table is quite heavy and the current situation is USERNO have reached
> it's maximum value i.e. 999999999.
> No more records can be inserted ....
>
> Problem !!!
>
> Can any one suggest a solution with NO change is the software and minor
> change in the software.
>
> TIA
>
> Regards,
> Harsh Agrawal
>

> --------------------------------------------------------------------
>
> The information contained in this message is proprietary of Amdocs,
> protected from disclosure, and may be privileged.
> The information is intended to be conveyed only to the designated
recipient(s)
> of the message. If the reader of this message is not the intended
recipient,
> you are hereby notified that any dissemination, use, distribution or
copying of
> this communication is strictly prohibited and may be unlawful.
> If you have received this communication in error, please notify us
immediately
> by replying to the message and deleting it from your computer.
> Thank you.
>
> --------------------------------------------------------------------
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Don Granaman
  INET: granaman_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).