| 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: MAX Length of Name for Table / Index ?
Banarasi Babu,
It is Oracle delivered (on UNIX platforms), shell script that takes the 'ORA NNNN' as argument, to display the description and cause of an oracle error from the Error Message file. It is free and gets installed when you install Oracle software, and is located in $ORACLE_HOME/bin directory. The Error Message file is in $ORACLE_HOME/rdbms/mesg directory.
-----Original Message-----
Sent: Sunday, January 19, 2003 11:34 PM
To: Multiple recipients of list ORACLE-L
Hi kirti
what is this oerr utility. Where can i found that one... Please give me details.
thanks in advance
Banarasi Babu
-----Original Message-----
Sent: Friday, January 17, 2003 7:34 PM
To: Multiple recipients of list ORACLE-L
1)
SVRMGR> create table A2345678901234567890123456789012345 (c number);
create table A234567890123456789012345678901234567890 (c number)
*
ORA-00972: identifier is too long
SVRMGR> !oerr ora 972
00972, 00000, "identifier is too long"
// *Cause: An identifier with more than 30 characters was specified.
// *Action: Specify at most 30 characters.
SVRMGR>
You can try this test for an Index ;)
2)
Larry & the gang decided that ;)
-----Original Message-----
Sent: Friday, January 17, 2003 5:59 AM
To: Multiple recipients of list ORACLE-L
What is the MAX possible Length of of Name for Table / Index ?
Why ?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.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 Mon Jan 20 2003 - 07:49:43 CST
 |
 |