This content has been marked as final. Show 3 replies
You do not say which gateway or version you are using but you are most likely hitting this restriction in the 11.2 DG4MSQL and DG4ODBC documentation -
Oracle Database Gateway for SQL Server does not support CALLBACK links. Trying a
CALLBACK link with the gateway will return the following error message:
ORA-02025: All tables in the SQL statement must be at the remote database
You could try rewriting the query using PL/SQL which may avoid the call back.
I tried every way I could but i am unable to rewrite the query can you please help me
SQL> select name from v$database;
SQL> select count(*) from xyz@OACNV
SQL> select count(*) From xyz;
The dblink to sqlserver is working fine no issues with it
Edited by: 988802 on Mar 1, 2013 12:04 PM
Some time ago I connected oracle with sqlserver like you. Every queries worked very slowly. To remedy I created materialized view from remote table (SQlServer) and it was solution. Mayby you can use it.