Oracal Error Codes
Contents |
and other
Oracle Error Codes List With Description
troubleshooting information in these books. List of Message Types oracle error codes table 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 And Solution
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 Handling
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 ora error 12154 eliminated in set function 01004 string data - right truncation 01005
Ora In Oracle
insufficient item descriptor areas 01006 privilege not revoked 01007 privilege not granted 01008 implicit zero-bit padding oracle error code 942 01009 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 http://www.oracle.com/pls/db92/db92.error_search?prefill=ORA- clause does not 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 https://docs.oracle.com/cd/E15817_01/appdev.111/b31228/appd.htm 08000 connection exception 08001 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
vid Type in oracle error text* *e.g.username (at oracle error code least 3 characters long) ora amd aud dbv drg epc exp img imp kup lcd lfi lpx lrm lsx mod ncr nid nmp nnc nnf nnl nno npl nze o2f o2i o2u pcb pcc pcf pls qsm rman sql sql*loader tns vid Error type information..... Search tips..... Oracle Support Copyright © Ora-error 2004-2012, all rights reserved.
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
Oracle Error Code List Oracle Database Tips by Burleson Consulting As of Oracle 10g, Oracle has 10,038 distinct Oracle error codes. This is only includes the ORA- prefix error codes: ORA-00056 ORA-00057 ORA-00058 ORA-00059 ORA-00060 ORA-00061 ORA-00062 ORA-00063 ORA-00064 ORA-00065 ORA-00066 ORA-00067 ORA-00068 ORA-00069 ORA-00070 ORA-00071 ORA-00072 ORA-00073 ORA-00074 ORA-00075 ORA-00076 ORA-00077 ORA-00078 ORA-00079 ORA-00080 ORA-00081 ORA-00082 ORA-00083 ORA-00084 ORA-00085 ORA-00086 ORA-00087 ORA-00088 ORA-00089 ORA-00090 ORA-00091 ORA-00092 ORA-00093 ORA-00094 ORA-00096 ORA-00097 ORA-00117 ORA-00118 ORA-00119 ORA-00120 ORA-00121 ORA-00122 ORA-00123 ORA-00124 ORA-00125 ORA-00126 ORA-00127 ORA-00128 ORA-00129 ORA-00130 ORA-00131 ORA-00132 ORA-00133 ORA-00134 ORA-00150 ORA-00151 ORA-00152 ORA-00153 ORA-00154 ORA-00155 ORA-00160 ORA-00161 ORA-00162 ORA-00163 ORA-00164 ORA-00165 ORA-00166 ORA-00200 ORA-00201 ORA-00202 ORA-00203 ORA-00204 ORA-00205 ORA-00206 ORA-00207 ORA-00208 ORA-00209 ORA-00210 ORA-00211 ORA-00212 ORA-00213 ORA-00214 ORA-00215 ORA-00216 ORA-00217 ORA-00218 ORA-00219 ORA-00220 ORA-00221 ORA-00222 ORA-00223 ORA-00224 ORA-00225 ORA-00226 ORA-00227 ORA-00228 ORA-00229 ORA-00230 ORA-00231 ORA-00232 ORA-00233 ORA-00234 ORA-00235 ORA-00236 ORA-00237 ORA-00238 ORA-00250 ORA-00251 ORA-00252 ORA-00253 ORA-00254 ORA-00255 ORA-00256 ORA-00257 ORA-00258 ORA-00259 ORA-00260 ORA-00261 ORA-00262 ORA-00263 ORA-00264 ORA-00265 ORA-00266 ORA-00267 ORA-00268 ORA-00269 ORA-00270 ORA-00271 ORA-00272 ORA-00273 ORA-00274 ORA-00275 ORA-00276 ORA-00277 ORA-00278 ORA-00279 ORA-00280 ORA-00281 ORA-00282 ORA-00283 ORA-00284 ORA-00285 ORA-00286 ORA-00287 ORA-00288 ORA-00289 ORA-00290 ORA-00291 ORA-00292 ORA-00293 ORA-00294 ORA-00295 ORA-00296 ORA-00297 ORA-00298 ORA-00299 ORA-00300 ORA-00301 ORA-00302 ORA-00303 ORA-00304 ORA-00305 ORA-00306 ORA-00307 ORA-00308 ORA-00309 ORA-00310 ORA-00311 ORA-00312 ORA-00313 ORA-00314 ORA-00315 ORA-00316 ORA-00317 ORA-00318 ORA-00319 ORA-00320 ORA-00321 ORA-00322 ORA-00323 ORA-00324 ORA-00325 ORA-00326 ORA-00327 O