| 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: How to change error messages?
LOL! Kirti. I'm thinking of trying out a binary editor on a TEST COPY of the oraus.msb file. It will at least be educational, whether successful or not.
--Scott
"Deshpande, Kirti" wrote:
>
> The oerr script will use the oraus.msg file.
> However, Oracle kernel will still use oraus.msb file that is a binay version
> of the msg file.
> Oracle does not give you any tool to convert your customized msg to msb.
>
> But, that's where the fun begins ;) ( I have played with this thing in my
> own TEST database. Yes, I said... TEST )
> Here is how :
> SQL> select * from mytable;
> select * from mytable
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> SQL> !oerr ora 942
> 00942, 00000, "Do you think this table or view exists? "
> // *Cause: It could be a typo.
> // *Action: Learn to type correctly.
>
> TGIF... :)
>
> Cheers!
>
> - Kirti
>
> > -----Original Message-----
> > From: Adams, Matthew (GEA, 088130) [SMTP:MATT.ADAMS_at_APPL.GE.COM]
> > Sent: Friday, September 07, 2001 9:56 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: How to change error messages?
> >
> > under $ORACLE_HOME/rdbms/mesg
> > there are many error messages files.
> >
> > the ones your looking for here are
> >
> > oraus.msg
> > oraus.msb
> >
> > The extention msg files are ascii text that you
> > can edit if you like (I used to do this a lot on Oracle 6 and 7),
> > but unless they have changed things since then, these files
> > are used only by the oerr utility.
> >
> > The msb files are binary files that are used by the executables
> > to look up error messages.
> >
> > BTW, the 'us' in the file name indicates us english. If you
> > are working with some other language, it will be oraXX.msg,
> > where XX indicates the language of the file.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: sknd100_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Fri Sep 07 2001 - 11:50:08 CDT
 |
 |