ORA-00904 'Invalid Column Name' or 'Invalid Identifier' Error When Running a Query Over a Database Link and All Columns Referenced Are Valid
Last updated on SEPTEMBER 04, 2015
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 10.2.0.3 [Release 9.2 to 10.2]
Information in this document applies to any platform.
ORA-00904 'Invalid Column Name' or 'Invalid Identifier' error occurs when running a query that uses a database link between 9.2, 10.1, or 10.2 databases. This error occurs when the query has mixed predicates.
An errorstack on the ORA-904 can be taken as follows:
SQL> << execute the failing SQL here >>
This will write a file to the udump directory. The file will contain a Call Stack Trace similar to the following, where the call stack identifiers in the list are the first column values of each row:
----- Call Stack Trace -----
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms