| 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: what is !oerr
Hi, Leslie,
If you happen to be using Windows instead of UNIX, other people's suggestion won't work for you. Instead, try installing my freeware program Windowsoerr available from http://www.stormloader.com/yonghuang/freeware/Windowsoerr.html
The current version needs you to install Perl (and of course Oracle documentation). But it's trivial to compile it into oerr.exe with per2exe (from www.perl2exe.com).
I use my program everyday! Here's a screen shot:
C:\>oerr ora 8106
ORA-08106 can not create journal table string.string
Cause: Online index builder cannot create its journal table.
Action: Rename your table in conflict.
Yong Huang
yong321_at_yahoo.com
you wrote:
In one of the listers' email, I saw this:
SQL> !oerr ora 8106
SQL> show error description
but when I execute this in SQL Plus, I got the
following:
SQL> !oerr ora 8106
SP2-0042: unknown command beginning "!oerr ora ..." -
rest of line ignored.
In which tool can you issue !oerr command. Also are there any other ways to show error description than going through Oracle Documentation?
Thank you in advance.
Leslie
 |
 |