INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- Turn Off Ad Banners
- 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
"...this web site is a 'Godsend' for me. If I have a programming problem that I'm unable to solve, I'll get a sensible reply in no time. It's really great!..."
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. |
|
|
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)) |
|
|
 |
|
