INTELLIGENT WORK FORUMS FOR COMPUTER PROFESSIONALS
Come Join Us!
Are you a Computer / IT professional? Join Tek-Tips now!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)
Member Feedback
"...These forums are an excellent source and example of the way people can help each other..."
Geography
Where in the world do Tek-Tips members come from?
|
ORACLE 9i error codes
|
|
|
cDevX99 (Programmer) |
8 Jan 02 10:25 |
Does anyone know the meaning of an error 1242, or 204. More importantly, is there a command ( either sqlplus or cmd line ) to describe an error based on it's number. |
|
Tek-Tips Forums is Member Supported. Click Here to donate.
|
tsclark (TechnicalUser) |
9 Jan 02 15:21 |
I know how to do it in 8.1.7. See if 9i has an oerr binary.
AIX6/home/oracle8i>oerr ora 1242 01242, 00000, "data file suffered media failure: database in NOARCHIVELOG mode" // *Cause: The database is in NOARCHIVELOG mode and a database file was // detected as inaccessible due to media failure. // *Action: Restore accessibility to the file mentioned in the error stack // and restart the instance. |
|
|
sem (Programmer) |
14 Jan 02 4:10 |
You may read Oracle manuals or use sqlerrm() function (don't forget about set serverout on):
exec dbms_output.put_line(sqlerrm(-1242)) |
|
|
 |
|