ORA-00904 'Invalid Column Name' or 'Invalid Identifier' Error When Running a Query Over a Database Link and All Columns Referenced Are Valid
(Doc ID 361084.1)

Last updated on SEPTEMBER 04, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.3 [Release 9.2 to 10.2]Information in this document applies to any platform.

Symptoms

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.