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
"...I am very happy with the whole site and would like to extend my compliments to all of you who work to make it one of the most useful sites (If not THE Most Useful) ...and the easiest to navigate..."
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)) |
|
|
 |
|
