Select From a Local View Which Queries Remote Tables Fails With ORA-00904/ORA-02063
Last updated on FEBRUARY 06, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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
The following error occurs between two 9.2 or 10g database instances, or on a single 9.2 or 10g database instance:
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).
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