Oracle 10gr2 Error List
Contents |
and other oracle 11g error codes troubleshooting information in these books. List of Message Types
Oracle Error Codes List With Description
ORA-00000 to ORA-00899 ORA-00900 to ORA-01499 ORA-01500 to ORA-02099 ORA-02100 to ORA-04099 ORA-04100 to oracle error sqlcode ORA-07499 ORA-07500 to ORA-09857 ORA-09858 to ORA-12299 ORA-12300 to ORA-12399 ORA-12400 to ORA-12699 ORA-12700 to ORA-19399 ORA-19400 to ORA-24279 ORA-24280 to ORA-29249
Oracle Error Codes Table
ORA-29250 to ORA-32799 ORA-32800 to ORA-32999 ORA-33000 to ORA-65535 BFILE-Related Messages (LFI) DBNEWID Messages (NID) DBVERIFY Messages (DBV) Export Messages (EXP) External Naming Messages (NNF) External Tables Messages (KUP) Import Messages (IMP) interMedia Audio Messages (AUD) interMedia Image Messages (IMG) interMedia Video Messages (VID) Network oracle error codes and solution Security Messages (NZE) Object Type Translator Initialization Messages (O2I) Object Type Translator Type File Messages (O2F) Object Type Translator Unparser Messages (O2U) Oracle Names Client Messages (NNC) Oracle Names Control Utility Messages (NNL) Oracle Names Server Messages (NNO) Oracle Names Server Network Presentation Layer Messages (NPL) Oracle Net Messages (TNS) Oracle OLAP Catalog Metadata Messages (AMD) Oracle Text Messages (DRG) Oracle Trace Collection Services Messages (EPC) Parameter Messages (LCD) Parameter Messages (LRM) PCF FIPS Messages (PCF) PL/SQL and FIPS Messages (PLS) Pro*C/C++ Messages (PCC) Pro*COBOL Messages (PCB) Recovery Manager Messages (RMAN) Remote Operation Messages (NCR) Simple Network Management Protocol Messages (NMP) SQL Runtime Messages (SQL) SQL*Module Messages (MOD) Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM) XML Parser Messages (LPX) XML Schema Processor Messages (LSX) Copyright © 2016, Oracle. All rights reserved.
_Font family, color, and size _Custom
Oracle Error Handling
cell format _Horizontal and vertical alignment _Bold, italic,
Ora Error 12154
and underline _Borders with styles and colors _Merge and align cells _Wrap text ora in oracle _Column width and row height _Multiple sheets _Multiple documents _Export from select _Add 1.048.576 rows to sheet _Save worksheet to XLSX file http://www.oracle.com/pls/db92/db92.error_search?prefill=ORA- _Save worksheet to BLOB _Set sheet paper size _Left and right text indent _Unlimited sheets per document _Set cell background color _Set column width _Set row height _Set sheet margins _Set sheet header and footer text _Set cell comment _Filter cells _Rotate text _Hide https://www.oraexcel.com/oracle-10gR2-- columns and rows _Set column formulas _Set sheet portrait or landscape _Set cell as hyperlink _Group columns _Save BLOB to file _Freeze panes vertical _Freeze panes horizontal _Cell style _Set document author _Set date system _Read xlsx document _Set active cell _List - data validation _Whole number - data validation _Decimal number - data validation _Date - data validation _Time - data validation _Text length - data validation Documentation add_sheet add_row query_to_sheet set_row_height set_cell_value set_cell_font set_default_font set_cell_bold set_cell_italic set_cell_underline set_cell_color set_cell_bg_color set_cell_align_left set_cell_align_right set_cell_align_center set_cell_vert_align_top set_cell_vert_align_middle set_cell_vert_align_bottom set_column_width set_cell_border_top set_cell_border_bottom set_cell_border_left set_cell_border_right set_cell_border set_cell_wrap_text merge_cells merge_rows set_cell_format set_cell_formula set_cell_rotate_text set_sheet_margins set_sheet_landscape set_sheet_paper_size set_sheet_header_text set_sheet_footer_text set_cell_hyperlink set_cell_indent_left set_cell_indent_right set_cell_comment hide_column hide_row set_cells_filter save_to_file save_to_blob set_1904_date_system set_1900_date_system set_document_author add_style set_cell_style freeze_panes_horizontal freeze_panes_vertical blob_to_file group_columns set_cell_validation_list set_cell_validation_integer set_cell_validation_decimal set_cell_validation_date set_cell_validation_time set_cell_validation_text_len Resour
listed in this site contains the message statement, an explanation of the probable causes of the message, and a recommended action. If the message is a warning or indicates that an error has http://www.oracle-error.com/ occurred, then the message listing will suggest a corrective action. This list was of course http://www.orafaq.com/node/76 drawn from the official Oracle documentation and updated several times thanks to the users' feedback. Each Oracle version holds its own error listing which can be easily accessed from the tabs above. Use the search function on right side to find and solve your error. Why this site ? This site aims to share experiences on specific Oracle error oracle error messages, through the exchange of comments. Of course, any assistance or participation will be greatly thanked. Common Oracle error codes encountered The following is a short list of the most common oracle errors : Oracle error 12154 : TNS:could not resolve the connect identifier specified Oracle error 904 : string : invalid identifier Oracle error 12560 : TNS:protocol adapter error Oracle error 1403 : no data found Oracle error 942 : table or view does not oracle error codes exist Oracle error 1017 : invalid username/password; logon denied Oracle error 6502 : PL/SQL: numeric or value error string Oracle error 1031 : insufficient privileges Oracle error 1722 : invalid number Oracle error 1034 : ORACLE not available Oracle error 3113 : end-of-file on communication channel Oracle error 12899 : value too large for column string (actual: string, maximum: string) Oracle error 12505 : TNS:listener does not currently know of SID given in connect descriptor Oracle error 3114 : not connected to ORACLE Oracle error 2291 : integrity constraint ( string . string ) violated - parent key not found Oracle error 1917 : user or role ‘ string ‘ does not exist Oracle error 12170 : TNS:Connect timeout occurred Oracle error 1405 : fetched column value is NULL Oracle error 1012 : not logged on Oracle error 1422 : exact fetch returns more than requested number of rows Oracle error 12541 : TNS:no listener History This website only deals with error messages from Oracle versions 8i to 11g (soon 12c) although there obviously have been previous versions before. Below is a brief preview of the history of Oracle versions. Year Version Release Comments 1977 - Software Development Laboratories was established. 1979 Oracle 2 SDL changed its name, thus becoming Relational Software, Inc. (RSI) and introduced its Oracle V2 product as a relational
12cR2 lots of new instance parameters 12cR2 new feature: online table move Transport Tablespace Testing from Msocial (Sparc) to STS VMWare (x86_64) Is row-by-row processing really slow-by-slow? Emphatically: YES How to change column order when using SELECT * Oracle 12cR2 - the next release, cloud only? Send SMTP Mail using UTL_SMTP Package Tips to install Oracle 11gr2 RAC on AIX (6.1/7.1) Create RAID hardware on Sun Sparc T5-2 Solaris 10 - Create software RAID 1 More You are hereHome » Blogs » Natalka Roshak's blog 10gR2 New Feature: DML Error Logging Submitted by Natalka Roshak on Sun, 2005-09-11 19:00 articles:SQL & PL/SQLDML error logging is a new feature for 10gR2. Have you ever tried to update 30 million records, only to have the update fail after twenty minutes because one record in 30 million fails a check constraint? Or, how about an insert-as-select that fails on row 999 of 1000 because one column value is too large? With DML error logging, adding one clause to your insert statement would cause the 999 correct records to be inserted successfully, and the one bad record to be written out to a table for you to resolve. This article will show you how to use DML error logging in your INSERT, UPDATE, MERGE and DELETE statements. Getting started Let's start by creating a table with a few constraints for us to violate: SQL> create table dmlel 2> (pkey varchar2(100) primary key, field1 varchar2(1), field2 varchar2(10) not null); Table created. Now, let's write a script that will fail without DML error logging. The following script will insert a few rows, and then fail with "value too large for column": declare i number; begin i := 0; while i <= 10 loop insert into dmlel (pkey, field1, field2) values (i, i, i); i := i+1; end loop; end; / * ERROR at line 1: ORA-12899: value too large for c