Oracle Error Code Search
Contents |
and other oracle error codes list 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.
them. SQLSTATE Codes Code Condition Oracle Error 00000 successful completion ORA-00000 01000 warning 01001 cursor operation conflict 01002 disconnect error 01003 null value eliminated in oracle error handling set function 01004 string data - right truncation 01005 insufficient item
Ora Error 12154
descriptor areas 01006 privilege not revoked 01007 privilege not granted 01008 implicit zero-bit padding 01009
Oracle Sqlcode Values
search condition too long for info schema 0100A query expression too long for info schema 02000 no data ORA-01095 ORA-01403 07000 dynamic SQL error 07001 using clause does not http://www.oracle.com/pls/db92/db92.error_search?prefill=ORA- match parameter specs 07002 using clause does not match target specs 07003 cursor specification cannot be executed 07004 using clause required for dynamic parameters 07005 prepared statement not a cursor specification 07006 restricted datatype attribute violation 07007 using clause required for result fields 07008 invalid descriptor count SQL-02126 07009 invalid descriptor index 08000 connection exception 08001 https://docs.oracle.com/cd/E15817_01/appdev.111/b31228/appd.htm SQL client unable to establish SQL connection 08002 connection name in use 08003 connection does not exist SQL-02121 08004 SQL server rejected SQL connection 08006 connection failure 08007 transaction resolution unknown 0A000 feature not supported ORA-03000 .. 03099 0A001 multiple server transactions 21000 cardinality violation ORA-01427 SQL-02112 22000 data exception 22001 string data - right truncation ORA-01401 ORA-01406 22002 null value - no indicator parameter ORA-01405 SQL-02124 22003 numeric value out of range ORA-01426 ORA-01438 ORA-01455 ORA-01457 22005 error in assignment 22007 invalid date-time format 22008 date-time field overflow ORA-01800 .. 01899 22009 invalid time zone displacement value 22011 substring error 22012 division by zero ORA-01476 22015 interval field overflow 22018 invalid character value for cast 22019 invalid escape character ORA-00911 ORA-01425 22021 character not in repertoire 22022 indicator overflow ORA-01411 22023 invalid parameter value ORA-01025 ORA-01488 ORA-04000 .. 04019 22024 unterminated C string ORA-01479 .. 01480 22025 invalid escape sequence ORA-01424 22026 string data - length mismatch 22027 trim error 23000 integrity constraint violation ORA-00001 ORA-02290 .. 02299 24000 invalid cursor state ORA-01001 .. 01003 ORA-01
Code Library mySQL Code Library PHP Code Library JavaScript http://psoug.org/oraerror.htm Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG http://www.dba-oracle.com/oracle_news/2004_11_10_easy_lookup_error_codes.htm Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us We have over 18,000 oracle error Oracle Error Codes currently indexed for searching, including error codes for SQL*Loader, RMAN, NNL, TNS, DRG, IMG, PCC, LPX, LSX, and many others. Type the Oracle Error code into the Search box to find the associated error: Or, browse the Oracle Error list below: ORA-00000: Normal, oracle error code successful completion ORA-00001: Unique constraint (string.string) violated ORA-00017: Session requested to set trace event ORA-00018: Maximum number of sessions exceeded ORA-00019: Maximum number of session licenses exceeded ORA-00020: Maximum number of processes (string) exceeded ORA-00021: Session attached to some other process; cannot ... ORA-00022: Invalid session ID; access denied ORA-00023: Session references process private memory; cann... ORA-00024: Logins from more than one process not allowed i... ORA-00025: Failed to allocate string ORA-00026: Missing or invalid session ID ORA-00027: Cannot kill current session ORA-00028: Your session has been killed ORA-00029: Session is not a user session ORA-00030: User session ID does not exist. ORA-00031: Session marked for kill ORA-00032: Invalid session migration password ORA-00033: Current session has empty migration password ORA-00034: Cannot string in current PL/SQL session ORA-00036: Maximum number of recursive SQL levels (string)... ORA-00037: Cannot switch to a session belonging to a diffe... ORA-00038: Cannot
release and press the "find Oracle error" button. Oracle Error Lookup 8i 9i 10g 9iAS AS10g