Oracle Database “Error 904: Invalid Identifier”

Asked By ronaldbarron 0 points N/A Posted on - 02/12/2012

1.     Oracle Database Error 904

 

Hello,

While I am trying to perform an admittedly complex SQL query in opposition to EDW with the Tableau Oracle data connection, I got an Oracle Database Error 904: Invalid Identifier.

It doesn’t provide any more information than that.  Perhaps this has something to do with that what types of functions or syntax Tableau doesn’t support for custom SQL queries? There are separate CASE functions and I am in doubt that these created the problem. Suggestions would be appreciated.  Thanks a lot.

• Status: Open
• Question Views: 2755
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By ilan aaroan 0 points N/A #95269

Oracle Database “Error 904: Invalid Identifier”

Oracle Database "Error 904: Invalid Identifier" issue please take below steps….

1. First of all you need to run CATEXP as INTERNAL. Then retry the export. Most times this fix this particular issue and the export should run without errors. Usually the cause of this issue has been a problem with object EXU8FIL being detected.
2. To determine if this object exists, you should run the following command:
3. SQL> select owner, object_name, object_type, object_id, status
4. From dba_objects
5. Where object_name = 'EXU8FIL';
6. If the problem is on the EXU8FIL object you simply can recreate the object by running the CATEXP.SQL script.

About ilan aaroan

Questions
1

Answers
19

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 02/12/2012
• Question Category: Oracle Database