Types of Oracle Error Message.

A typical oracle error message follow the following form.

Prefix-ErrorNumber: Error Text
An example of error message is,
ORA-00942: table or view does not exist
Here ORA is prefix and error number is 00942 , The error text is "table or view does not exist".

The types of Error Message in oracle are,


ORA Oracle RDBMS errors
AMD Oracle OLAP Catalog Metadata Messages
AUD interMedia Audio Messages
DBV DBVERIFY Messages
DRG Oracle Text Messages
EPC Oracle Trace Collection Services Messages
EXP Export Messages
IMG interMedia Image Messages
IMP Import Messages
KUP External Tables Messages
LCD Parameter Messages
LFI BFILE-related messages
LPX XML Parser Messages
LRM Parameter Messages
LSX XML Schema Processor Messages
MOD SQL*Module Messages
NCR Remote Operation Messages
NID DBNEWID Messages
NMP Simple Network Management Protocol Messages
NNC Oracle Names Client Messages
NNF External Naming Messages
NNL Oracle Names Control Utility Messages
NNO Oracle Names Server Messages
NPL Oracle Names Server Network Presentation Layer Messages
NZE Network Security Messages
O2F Object Type Translator Type File Messages
O2I Object Type Translator Initialization Messages
O2U Object Type Translator Unparser Messages
PCB Pro*COBOL Messages
PCF PCF FIPS Messages
PLS PL/SQL and FIPS Messages
QSM Summary Advisor, Explain Rewrite, and Explain Materialized View Messages
RMAN Recovery Manager Messages
SQL SQL Runtime Messages
SQL*LOADER SQL*Loader Messages
TNS Oracle Net Messages
VID interMedia Video Messages

Related Documents
How to get Oracle Error Message from Database or OS