ORA-00910: specified length too long for its datatype
Cause: for datatypes CHAR and RAW, the length specified was > 2000; otherwise, the length specified was > 4000
Action: use a shorter length or switch to a datatype permitting a longer length such as a VARCHAR2, LONG CHAR, or LONG RAW
ORA-00909: invalid number of arguments
Cause: An Oracle function was referenced with an incorrect number of arguments. All Oracle functions, except for SYSDATE, require at least one argument
Action: Correct the syntax of the function by entering the required number of arguments
ORA-00908: missing NULL keyword
Cause: Either of the following: In a CREATE TABLE or ALTER TABLE statement, NOT was entered to specify that no null values are allowed in that column, but the keyword NULL was omitted. In the IS [NOT] NULL logical operator, the keyword NULL was not found. For example, the following statement generates this message:
SELECT * FROM EMP WHERE DEPTNO IS NOT; The keyword NULL must follow the keywords IS NOT
Action: Correct the syntax
ORA-00907: missing right parenthesis
Cause: A left parenthesis has been entered without a closing right parenthesis, or extra information was contained in the parentheses. All parentheses must be entered in pairs
Action: Correct the syntax and retry the statement
ORA-00906: missing left parenthesis
Cause: A required left parenthesis has been omitted. Certain commands, such as CREATE TABLE, CREATE CLUSTER, and INSERT, require a list of items enclosed in parentheses. Parentheses also are required around subqueries in WHERE clauses and in UPDATE table SET column = (SELECT…) statements
Action: Correct the syntax, inserting a left parenthesis where required, and retry the statement
ORA-00905: missing keyword
Cause: A required keyword is missing
Action: Correct the syntax
ORA-00904: string: invalid identifier
Cause: The column name entered is either missing or invalid
Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word
ORA-00903: invalid table name
Cause: A table or cluster name is invalid or does not exist. This message is also issued if an invalid cluster name or no cluster name is specified in an ALTER CLUSTER or DROP CLUSTER statement
Action: Check spelling. A valid table name or cluster name must begin with a letter and may contain only alphanumeric characters and the special characters $, _, and #. The name must be less than or equal to 30 characters and cannot be a reserved word
ORA-00902: invalid datatype
Cause: The datatype entered in the CREATE or ALTER TABLE statement is not valid
Action: Correct the syntax
ORA-00901: invalid CREATE command
Cause: The CREATE command was not followed by a valid CREATE option
Action: Correct the syntax