ORACLE 9i error codes

[cDevX99]

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]

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]

You may read Oracle manuals or use sqlerrm() function (don't forget about set serverout on):


exec dbms_output.put_line(sqlerrm(-1242))