ORA-00972 : identifier is too long
Cause : The name of a schema object exceeds 30 characters. Schema objects are tables, clusters, views, indexes, synonyms, tablespaces, and usernames.
Action : Shorten the name to 30 characters or less.
Popularity: 2% [?]
ORA-00971 : missing SET keyword
Cause : The keyword SET in an UPDATE statement is missing, misspelled, or misplaced.
Action : Check syntax and spelling, and use the keyword SET after the name of the table to be updated.
Popularity: 3% [?]
ORA-00970 : missing WITH keyword
Cause : The keyword START was specified without the keyword WITH. Both keywords are necessary if a START WITH clause is desired in a tree-structured query.
Action : Change the keyword START to the keywords START WITH. Then retry the statement.
Popularity: 2% [?]
ORA-00969 : missing ON keyword
Cause : The keyword ON in a GRANT, REVOKE, or CREATE INDEX statement was missing, misspelled, or misplaced.
Action : Check syntax and spelling, and use the keyword ON where required.
Popularity: 5% [?]
ORA-00968 : missing INDEX keyword
Cause : The keyword INDEX in a CREATE UNIQUE INDEX or VALIDATE INDEX statement was missing, misspelled, or misplaced.
Action : Correct the syntax.
Popularity: 3% [?]
ORA-00967 : missing WHERE keyword
Cause : The keyword WHERE in a SELECT statement was missing, misspelled, or misplaced.
Action : Correct the syntax.
Popularity: 2% [?]
ORA-00966 : missing TABLE keyword
Cause : A LOCK statement was specified and the keyword TABLE was missing, misspelled, or misplaced. A LOCK statement must begin with LOCK TABLE tablename.
Action : Correct the syntax.
Popularity: 2% [?]
ORA-00965 : column aliases not allowed for ‘*’
Cause : An alias was used with the return-all-columns function (*) in the
SELECT list. For example:
SELECT * COL_ALIAS FROM EMP;
Action: Either specify individual columns or do not specify an alias with a “*”.
Popularity: 2% [?]
ORA-00964 : table name not in FROM list
Cause : A table specified in a query’s SELECT list is not named in the FROM clause list.
Action : Check spelling of the table names, check that each table name in the SELECT list matches a table name in the FROM list, and then retry the statement.
Popularity: 2% [?]
