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

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