Is there an Oracle expert in the house??

From: Kevin Purcell <purcell_at_iag.net>
Date: 1996/08/27
Message-ID: <3223673f.1611427_at_news.iag.net>#1/1


I am trying to access a remote database table with a database link and having some problems. The SQL command is the simple one below:

select * from TABLE_at_dblink;

I created the database link and the table does exist but I keep receiving the error ORA-02070: database dblink does not support select in this context. The Server message book says to simplify the SQL statement. How??

The Remote database machine is running (WIN NT 3.51) Oracle Workgroup Server Release 7.2.2.4.0 PL/SQL Release 2.2.2.3.1
SQL*NET 1.0
SQL*NET 2.X The local database machine is running (Unixware 1.1) Oracle Server Release 7.0.12.2.0
PL/SQL Relase 2.0.14.0.1
SQL*NET 1.0 I can connect to the remote database and do the select query from there. I have gotten this to work on two unixware machines.

Any help you can give will be greatly appreciated.

Kevin Purcell
purcell_at_iag.net Received on Tue Aug 27 1996 - 00:00:00 CEST

Original text of this message