OraFAQ Forum: SQL & PL/SQL » Where to find oracle error code explanation

Home » SQL & PL/SQL » SQL & PL/SQL » Where to find oracle error code explanation

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

Where to find oracle error code explanation [message #23539]

Mon, 16 December 2002 08:09

Reddy Peram
Messages: 52
Registered: December 2002

Member

Hi,
While running SQL in Oracle, if we get any error, it gives error code. Where to find explanation for that sql error code in UNIX, NT and SQL plus envoronments?

Report message to a moderator

Re: Where to find oracle error code explanation [message #23540 is a reply to message #23539]

Mon, 16 December 2002 08:11

Jon
Messages: 483
Registered: May 2001

Senior Member

http://download-west.oracle.com/docs/cd/A91202_01/901_doc/server.901/a90202/toc.htm

Report message to a moderator

Re: Where to find oracle error code explanation [message #23554 is a reply to message #23539]

Tue, 17 December 2002 03:23

Arathi
Messages: 9
Registered: November 2002

Junior Member

In Unix You can get the error message as follows:
oerr ora <errorcode>

eg: oerr ora 1403

{ You get this only if you have an oracle installation in Unix, I think)

You can also look up the error messages online through sites like metalink.oracle.com

Report message to a moderator

Previous Topic:	How to calculate the difference of dates in HH:MI:SS format
Next Topic:	How to see current maxextents nonsystem-tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 06 04:02:39 CDT 2026