N/APosted on - 02/12/2012
1. Oracle Database Error 904
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.
Oracle Database “Error 904: Invalid Identifier”
Oracle Database "Error 904: Invalid Identifier" issue please take below steps….
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.
To determine if this object exists, you should run the following command:
SQL> select owner, object_name, object_type, object_id, status
Where object_name = 'EXU8FIL';
If the problem is on the EXU8FIL object you simply can recreate the object by running the CATEXP.SQL script.