Oracle Error Codes (ORA-00601 to ORA-00999)

ORA-00601: cleanup lock conflict

ORA-00602: internal programming exception

ORA-00603: fatal ORACLE error occurred; unwise to proceed

ORA-00604: error occurred at recursive SQL level num

ORA-00700: maximum number of row cache object (parameter ‘name’) exceeded

ORA-00701: object necessary for warmstarting database cannot be altered

ORA-00702: maximum number of row cache enqueues exceeded

ORA-00703: maximum number of row cache instance locks exceeded

ORA-00816: error message translation failed

ORA-00900: invalid SQL statement

ORA-00901: invalid CREATE command

ORA-00902: invalid datatype

ORA-00903: invalid table name

ORA-00904: invalid column name

ORA-00905: missing keyword

ORA-00906: missing left parenthesis

ORA-00907: missing right parenthesis

ORA-00908: missing NULL keyword

ORA-00909: invalid number of arguments

ORA-00910: specified length too large for CHAR column

ORA-00911: invalid character

ORA-00913: too many values

ORA-00914: missing ADD keyword

ORA-00915: network access of dictionary table not currently allowed

ORA-00917: missing comma

ORA-00918: column ambiguously defined

ORA-00919: invalid function

ORA-00920: invalid relational operator

ORA-00921: unexpected end of SQL command

ORA-00922: invalid option

ORA-00923: FROM keyword not found where expected

ORA-00924: missing BY keyword

ORA-00925: missing INTO keyword

ORA-00926: missing VALUES keyword

ORA-00927: missing equal sign

ORA-00928: missing SELECT keyword

ORA-00929: missing period

ORA-00930: missing asterisk

ORA-00931: missing identifier

ORA-00932: inconsistent datatypes

ORA-00933: SQL command not properly ended

ORA-00934: group function is not allowed here

ORA-00935: group function is nested too deeply

ORA-00936: missing expression

ORA-00937: not a single-group function

ORA-00938: not enough arguments for function

ORA-00939: too many arguments for function

ORA-00940: invalid ALTER command

ORA-00941: missing cluster name

ORA-00942: table or view does not exist

ORA-00943: cluster does not exist

ORA-00944: insufficient number of clustered columns

ORA-00945: specified clustered column does not exist

ORA-00946: missing TO keyword

ORA-00947: illegal use of LONG datatype

ORA-00947: not enough values

ORA-00949: illegal reference to remote database

ORA-00950: invalid DROP option

ORA-00951: cluster not empty

ORA-00952: missing GROUP keyword

ORA-00953: missing index name

ORA-00954: missing IDENTIFIED keyword

ORA-00955: name is already used by an existing object

ORA-00956: invalid auditing option

ORA-00957: duplicate column name

ORA-00958: missing CHECK keyword

ORA-00959: tablespace ‘name’ does not exist

ORA-00964: table name not in FROM list

ORA-00965: column aliases not allowed for

ORA-00966: missing TABLE keyword

ORA-00967: missing WHERE keyword

ORA-00968: missing INDEX keyword

ORA-00969: missing ON keyword

ORA-00970: missing WITH keyword

ORA-00971: missing SET keyword

ORA-00972: nidentifier is too long

ORA-00974: invalid PCTFREE value (percentage)

ORA-00975: date + date not allowed

ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here

ORA-00977: duplicate auditing option

ORA-00978: nest group function without GROUP BY

ORA-00979: not a GROUP BY expression

ORA-00980: translation is no longer valid

ORA-00981: cannot mix table and system-wide auditing options

ORA-00982: missing plus sign

ORA-00983: cannot define ROWID column – no corresponding SQL datatype

ORA-00984: column not allowed here

ORA-00985: invalid program name

ORA-00986: missing or invalid group names(s)

ORA-00987: missing or invalid username(s)

ORA-00988: missing or invalid password(s)

ORA-00989: too many passwords for usernames given

ORA-00990: missing or invalid privilege

ORA-00991: invalid format for GRANT command

ORA-00992: invalid format for REVOKE command

ORA-00993: missing GRANT keyword

ORA-00994: missing OPTION keyword

ORA-00995: missing or invalid synonym identifier

ORA-00996: the concatenate operator is || not |

ORA-00998: must name this expression width a column alias

ORA-00999: invalid view name

  • I respect your piece of function, appreciate it for all the intriguing content .