Oracle error codes
24 codes — tap one for its meaning, causes, and fix steps.
- ORA-00001unique constraint violated — duplicate value in unique index
- ORA-00054resource busy and acquire with NOWAIT specified — lock unavailable
- ORA-00060deadlock detected while waiting for resource
- ORA-00904invalid identifier — the column or alias name is not recognized
- ORA-00911invalid character — the SQL statement contains an unexpected character
- ORA-00918column ambiguously defined — the column name matches more than one table in the query
- ORA-00933SQL command not properly ended — unexpected token at the end of the statement
- ORA-00942table or view does not exist — the named object is not accessible
- ORA-00955name is already used by an existing object — DDL name conflict
- ORA-01017invalid username/password — logon denied
- ORA-01400cannot insert NULL into a NOT NULL column
- ORA-01403no data found — a SELECT INTO or FETCH returned no rows
- ORA-01422exact fetch returns more than requested number of rows — SELECT INTO got multiple rows
- ORA-01438value larger than specified precision — numeric overflow
- ORA-01555snapshot too old — the undo segment needed to reconstruct an old version of a row has been overwritten
- ORA-01722invalid number — a character string could not be converted to a number
- ORA-01840input value not long enough for date format — string too short for the date mask
- ORA-02291integrity constraint violated — parent key not found
- ORA-02292integrity constraint violated — child record found on delete
- ORA-04031unable to allocate shared memory — the shared pool or large pool is exhausted
- ORA-08177cannot serialize access for this transaction — serialization conflict
- ORA-12154TNS could not resolve the connect identifier specified — connection descriptor not found
- ORA-12514TNS listener does not currently know of service requested — service not registered
- ORA-12541TNS no listener — connection refused because nothing is listening on the port