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.
- Kirti
-----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 ;)
- Kirti
-----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: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
