Complete Source for Oracle Error Code Ora-, Pl/Sql Tips and Tricks and Oracle Error Message Description
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: 3% [?]
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% [?]
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% [?]
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% [?]
Cause : The keyword INDEX in a CREATE UNIQUE INDEX or VALIDATE INDEX statement was missing, misspelled, or misplaced.
Action : Correct the syntax.
Popularity: 3% [?]
Cause : The keyword WHERE in a SELECT statement was missing, misspelled, or misplaced.
Action : Correct the syntax.
Popularity: 2% [?]
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% [?]
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% [?]
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% [?]
Cause: An unsupported interval type was encountered.
Action: Use a valid interval type.
Popularity: 3% [?]
