Select From a Local View Which Queries Remote Tables Fails With ORA-00904/ORA-02063 (Doc ID 331807.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.1 [Release 9.2 to 10.2]
Information in this document applies to any platform.
Checked for currency on 21st June 2013

Symptoms

The following error occurs between two 9.2 or 10g database instances, or on a single 9.2 or 10g database instance:

 

ORA-00904: "<alias>"."<column_name>": invalid identifier



The 'alias' and 'column_name' likely won't be recognizable from any user-initiated DML - they are internally generated.  This error can be as a result of internally generated SQL on remote databases from distributed transactions or queries, or from internally generated SQL by local parallel query slaves for local operations.  For the former case, the error would be accompanied by an ORA-02063 'preceding line from <dblink_name>' error.

 

The same query does not return an error when run between two 8.1.7 instances (distributed transaction or query), or on a single 8.1.7 instance (parallel query).

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