Oracle Error Messages

Error: ORA-00903: invalid table name
Cause: You tried to execute an SQL statement that included an invalid table name or the table name does not exist.
Action: The options to resolve this Oracle error are:
.Rewrite your SQL to include a valid table name. To be a valid table name the following criteria must be met:
.The table name must begin with a letter.
.The table name can not be longer than 30 characters.
.The table name must be made up of alphanumeric characters or the following special characters: $, _, and #.
.The table name can not be a reserved word.

Error: ORA-00904: invalid column name
Cause: You tried to execute an SQL statement that included an invalid column name or the column name is missing.
Action: The options to resolve this Oracle error are:
.Rewrite your SQL to include a valid column name. To be a valid column name the following criteria must be met:
.The column name must begin with a letter.
.The column name can not be longer than 30 characters.
.The column name must be made up of alphanumeric characters or the following special characters: $, _, and #. If the column name uses any other characters, it must be enclosed in double quotation marks.
.The column name can not be a reserved word.

Error: ORA-00905: missing keyword
Cause: You tried to execute a statement, but you missed a required keyword.
Action: The options to resolve this Oracle error are:
.Try fixing the statement and re-executing.

Error: ORA-00906: missing left parenthesis
Cause: You tried to execute a statement, but you missed entering a required left parenthesis.
Action: The options to resolve this Oracle error are:
.Statements such as CREATE TABLE, INSERT Statements, Subqueries, and IN Function require items to be enclosed in parentheses. Try fixing the statement and re-executing.

Error: ORA-00907: missing right parenthesis
Cause: You entered a left parenthesis, but missed the closing right parenthesis; or you entered invalid data within the parentheses.
Action: The options to resolve this Oracle error are:
.All parentheses must be entered in pairs. You must correct the statement and re-execute.

Error: ORA-00908: missing NULL keyword
Cause: You tried to execute an SQL statement, but you missed entering the NULL keyword.
Action: The options to resolve this Oracle error are:
.This error can occur if you try to execute an SQL statement using the IS NULL or IS NOT NULL clause, but miss entering the NULL keyword.

Error: ORA-00909: invalid number of arguments
Cause: You tried to call an Oracle function, but you used the incorrect number of arguments for the function.
Action: The options to resolve this Oracle error are:
.This error can be corrected by providing the correct number of arguments when calling the Oracle function.

Error: ORA-00910: specified length too long for its datatype
Cause: You tried to create a VARCHAR2 or CHAR column, but you specified a length that exceeded Oracle's limits.
Action: The options to resolve this Oracle error are:
.Enter a maximum length for the VARCHAR2 or CHAR column that falls within Oracle's limits.

Error: ORA-00911: invalid character
Cause: You tried to tried to execute an SQL statement that included a special character.
Action: The options to resolve this Oracle error are:
.This error occurs when you try to use a special character in an SQL statement. If a special character other than $, _, and # is used in the name of a column or table, the name must be enclosed in double quotations.
.This error may occur if you've pasted your SQL into your editor from another program. Sometimes there are non-printable characters that may be present. In this case, you should try retyping your SQL statement and then re-execute it.
.This error occurs when a special character is used in a WHERE clause and the value is not enclosed in single quotations.

Error: ORA-00913: too many values
Cause: You tried to execute an SQL statement that required two sets of equal values, but you entered more items in the second set than was in the first set.
Action: The options to resolve this Oracle error are:
.This error often occurs when you are performing an INSERT statement and enter more values in the VALUES clause than the number of columns that you listed.

Error: ORA-00917: missing comma
Cause: You tried to execute a statement, but you missed a required comma.
Action: The options to resolve this Oracle error are:
.Try fixing the statement and re-executing.

Error: ORA-00918: column ambiguously defined
Cause: You tried to execute an SQL statement that joined two or more tables, where a column with the same name exists in both tables.
Action: The options to resolve this Oracle error are:
.refix the column with the table name and then re-execute the statement.

Error: ORA-00919: invalid function
Cause: You tried to call a function, but the name you used was not a valid Oracle function.
Action: The options to resolve this Oracle error are:
.Correct the spelling of the Oracle function that you wish to call.
.For a complete listing of Oracle functions, go to our Oracle functions webpage.

.Try using the dual table if you wish to call a function without querying a table.

Error: ORA-00920: invalid relational operator
Cause: You tried to execute an SQL statement, but the WHERE clause contained an invalid relational operator.
Action: The options to resolve this Oracle error are:
.Correct the WHERE clause. Valid relational operators

Error: ORA-00923: FROM keyword not found where expected
Cause: You tried to execute a SELECT statement, and you either missed or misplaced the FROM keyword.
Action: The options to resolve this Oracle error are:
.This error can occur when executing a SELECT statement.

Error: ORA-00924: missing BY keyword
Cause: You tried to execute a GROUP BY, ORDER BY, CONNECT BY, or GRANT (with IDENTIFIED) statement and missed the BY keyword.
Action: The options to resolve this Oracle error are:
.Try adding the missing BY keyword and re-execute the statement.

Error: ORA-00925: missing INTO keyword
Cause: You tried to execute an INSERT statement and missed the INTO keyword.
Action: The options to resolve this Oracle error are:
.Try adding the missing INTO keyword and re-execute the statement.

Error: ORA-00926: missing VALUES keyword
Cause: You tried to execute an INSERT statement and missed the VALUES keyword.
Action: The options to resolve this Oracle error are:
.Try adding the missing VALUES keyword or use a sub-select. Then re-execute the statement.

Error: ORA-00927: missing equal sign
Cause: You tried to execute a statement, but missed an equal sign. This can happen in either the SET clause of an UPDATE statement or in a search condition.
Action: The options to resolve this Oracle error are:
.If this error occurred in the SET clause of an UPDATE statement, add the missing equal sign and re-execute the statement.
.If this error occurred in a search condition when you are trying to determine a "not equals" condition, add the missing equal sign and re-execute the statement.

Error: ORA-00928: missing SELECT keyword
Cause: You tried to create a view, but missed the SELECT keyword.
Action: The options to resolve this Oracle error are:
.Correct the CREATE VIEW statement and re-execute it.

Error: ORA-00931: missing identifier
Cause: This is an internal error message.
Action: The options to resolve this Oracle error are:
.Contact customer support.

Error: ORA-00932: inconsistent datatypes
Cause: You tried to perform an operation between two different datatypes, but the datatypes are not compatible.
Action: The options to resolve this Oracle error are:
.Correct the operation so that the datatypes are compatible. You may want to use a conversion function such as: to_date, to_number, or to_char. For a complete listing of our Oracle functions, go to our Oracle functions webpage.
.This error can also occur if you try to use an Oracle function on a LONG datatype

Error: ORA-00933: SQL command not properly ended
Cause: You tried to execute an SQL statement with an inappropriate clause.
Action: The options to resolve this Oracle error are:
.You may have executed an INSERT statement with an ORDER BY Clause. To resolve this, remove the ORDER BY clause and re-execute the INSERT statement.
.You may have tried to execute a DELETE statement with an ORDER BY Clause. To resolve this, remove the ORDER BY clause and re-execute the DELETE statement.

Error: ORA-00934: group function is not allowed here
Cause: You tried to execute an SQL statement that included one of the group functions (ie: MIN, MAX, SUM, COUNT) in either the WHERE clause or the GROUP BY clause.
Action: The options to resolve this Oracle error are:
.Try removing the group function from the WHERE clause or GROUP BY clause. If required, you can move the group function to the HAVING clause.
.You could also try moving the group by function to a subquery.

Error: ORA-00935: group function is nested too deeply
Cause: This is an internal error message.
Action: The options to resolve this Oracle error are:
.Contact customer support.