Monday, May 19, 2008

Types of Oracle Error Message.

Types of Oracle Error Message.
A typical oracle error message follow the following form.Prefix-ErrorNumber: Error TextAn example of error message is,
ORA-00942: table or view does not existHere 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 errorsAMD Oracle OLAP Catalog Metadata MessagesAUD interMedia Audio MessagesDBV DBVERIFY MessagesDRG Oracle Text MessagesEPC Oracle Trace Collection Services MessagesEXP Export MessagesIMG interMedia Image MessagesIMP Import MessagesKUP External Tables MessagesLCD Parameter MessagesLFI BFILE-related messagesLPX XML Parser MessagesLRM Parameter MessagesLSX XML Schema Processor MessagesMOD SQL*Module MessagesNCR Remote Operation MessagesNID DBNEWID MessagesNMP Simple Network Management Protocol MessagesNNC Oracle Names Client MessagesNNF External Naming MessagesNNL Oracle Names Control Utility MessagesNNO Oracle Names Server MessagesNPL Oracle Names Server Network Presentation Layer MessagesNZE Network Security MessagesO2F Object Type Translator Type File MessagesO2I Object Type Translator Initialization MessagesO2U Object Type Translator Unparser MessagesPCB Pro*COBOL MessagesPCF PCF FIPS MessagesPLS PL/SQL and FIPS MessagesQSM Summary Advisor, Explain Rewrite, and Explain Materialized View MessagesRMAN Recovery Manager MessagesSQL SQL Runtime MessagesSQL*LOADER SQL*Loader MessagesTNS Oracle Net MessagesVID interMedia Video Messages

No comments: