Home » Other » General » HOW TO GET ORACLE HELP??? (where to find the error description)
HOW TO GET ORACLE HELP??? [message #275682] Mon, 22 October 2007 06:04 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Files in binary format: $ORACLE_HOME/rbdms/mesg/*.msb

Regards
Michel
Re: HOW TO GET ORACLE HELP??? [message #275692 is a reply to message #275687] Mon, 22 October 2007 06:48 Go to previous messageGo to next message
Maaher
Messages: 7062
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
Re: HOW TO GET ORACLE HELP??? [message #275696 is a reply to message #275692] Mon, 22 October 2007 07:27 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Also see http://orafaq.com/wiki/Oerr
Re: HOW TO GET ORACLE HELP??? [message #275705 is a reply to message #275696] Mon, 22 October 2007 08:01 Go to previous message
Frank
Messages: 7880
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.
Previous Topic: sample resumes for ab initio
Next Topic: Oracle Database 11g Launch
Goto Forum:
  


Current Time: Tue Dec 06 12:36:35 CST 2016

Total time taken to generate the page: 0.09973 seconds