Oracle utilities oerr windows

For Oracle support & training call (800) 766-1884

Oracle Utilities - Using Hidden Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof and More

oerr on Windows

oerr is only available on UNIX , but it does not take much code to access the same message file and display the same messages on a Windows machine. To do this, the actual message file must be ftp’d from a UNIX host to the Windows machine and placed in the same directory as the Java program.

The Java program below (oerr.java) reads the message file and displays the text associated with the error code:

SEE CODE DEPOT

This program was designed to resemble oerr on UNIX as much as possible. It processes facility names, though the ORA facility is the only one used in this program. Other facilities and their message files could easily be added to the program.

The Java program reads the message file line by line until it encounters the actual error code. While it does take more time to retrieve an error message located at the end of the file, the message is returned within a second, even when processing large message files.

To execute this program would require the following syntax:

C:\oracle9i\bin\java oerr ora 00942

To make it easier to execute the program and make it resemble oerr even more, the oerr.bat file below can be created to insulate the user from typing the “java” keyword on the command line.

SEE CODE DEPOT

Executing the bat file above from the DOS prompt, the command will work exactly as it does in UNIX:

C:\oracle9i\bin\oerr ora 00942
00942, 00000, "table or view does not exist"
// *Cause:
// *Action:

The next section will specify a way to deal with the apparent lack of information in the output listed above

The above is an excerpt from Oracle Utilities - Using Hidden Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof and More by Rampant TechPress.

For more details on Oracle utilities, see the book "Advanced Oracle Utilities" by Bert Scalzo, Donald K. Burleson, and Steve Callan.

You can buy it direct from the publisher for 30% off directly from Rampant TechPress.

For more details and scripts, see my new book " Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts.

You can buy it direct from the publisher for 30%-off and get instant access to the code depot.

Fast-Track Oracle Support
PO Box 511
Kittrell, NC 27544

Email BC: