Oracle Database “Error 904: Invalid Identifier”

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #95269

Oracle Database “Error 904: Invalid Identifier”

qa-featured

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.

Related Questions