| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Urgent - Help ....
u need to increase the length of the field USERNO and make corresponding
changes in the application where you are accessing this field.
Syntax will be something like this
Alter table <table_name> modify <column_name>;
HTH
Kranti
Harsh Agrawal
<HARSHA_at_Amdocs.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent by: cc:
root_at_fatcity.com Subject: Urgent - Help ....
02/20/2003 02:28 PM
Please respond to
ORACLE-L
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.
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: kranti.pushkarna_at_accenture.com
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). Received on Thu Feb 20 2003 - 04:53:57 CST
 |
 |