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 126.96.36.199 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 -----
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|