Troubleshooting and Resolving "ORA-00904: string: invalid identifier" Error

smallwei 7:02 am on October 30, 2009 | Answers: 1    
Tags: database (51), identifier (4), ora (7), oracle (136), resolving (35), sql (43), string (21), troubleshooting (30)

Rate Knowledge:

 Loading ...

• smallwei 7:02 am on October 30, 2009
  

  Here is the official Oracle explanation:
  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.

  Steps to troubleshoot:

  1. Check the column names in your sql statement. Make sure there is no typo, and the format is valid according to the standard above.
  2. Make sure you are NOT use any Oracle reserved words as your column or table name.
  3. Try to run $ORACLE_HOME/rdbms/admin/catproc.sql again.
  4. Enable trace logging to see the detail of the error.