OraFAQ Forum: General » HOW TO GET ORACLE HELP???

Home » Other » General » HOW TO GET ORACLE HELP??? (where to find the error description)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HOW TO GET ORACLE HELP??? [message #275682]

Mon, 22 October 2007 06:04

sonalir
Messages: 6
Registered: October 2007
Location: mumbai

Junior Member

when we excecute any query it display error message.so from where we get the meaning of that error message.

[mod-edit]Added message body.

[Updated on: Mon, 22 October 2007 06:14] by Moderator

Report message to a moderator

Re: HOW TO GET ORACLE HELP??? [message #275687 is a reply to message #275682]

Mon, 22 October 2007 06:19

Michel Cadot
Messages: 68508
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Files in binary format: $ORACLE_HOME/rbdms/mesg/*.msb

Regards
Michel

Report message to a moderator

Re: HOW TO GET ORACLE HELP??? [message #275692 is a reply to message #275687]

Mon, 22 October 2007 06:48

Maaher
Messages: 7065
Registered: December 2001

Senior Member

From the Unix prompt you can use "oerr":

mymachine.myuser:/>oerr ora 1555
01555, 00000, "snapshot too old: rollback segment number %s with name \"%s\" too
 small"
// *Cause: rollback records needed by a reader for consistent read are
//         overwritten by other writers
// *Action: If in Automatic Undo Management mode, increase undo_retention
//          setting. Otherwise, use larger rollback segments
mymachine.myuser:/>

MHE

Report message to a moderator

Re: HOW TO GET ORACLE HELP??? [message #275696 is a reply to message #275692]

Mon, 22 October 2007 07:27

Frank Naude
Messages: 4575
Registered: April 1998

Senior Member

Also see http://orafaq.com/wiki/Oerr

Report message to a moderator

Re: HOW TO GET ORACLE HELP??? [message #275705 is a reply to message #275696]

Mon, 22 October 2007 08:01

Frank
Messages: 7897
Registered: March 2000

Senior Member

Google is my first go.
It not only finds the definition, because somehow a zillion people think it convenient to dump Oracle's docs on their site, but also it often reveals some exceptions on general occurrences of the error.

Report message to a moderator

Previous Topic:	sample resumes for ab initio
Next Topic:	Oracle Database 11g Launch

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 28 07:06:18 CDT 2023