My Oracle Support Banner

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.

An errorstack on the ORA-904 can be taken as follows:

SQL> alter session set events '904 trace name errorstack level 3';
SQL> << execute the failing SQL here >>
SQL> exit

 

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 -----

ksedmp ksddoa ksdpcg ksdpec ksfpec kgesev kgesec1 qcuErr904 sqnprs qcsrnr qcsridn qcsraic qcspqb kkmdrv opiSem opiprs

 

Cause

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
Symptoms
Cause
Solution
References

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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.