How to call a table with oracle dblink

[#1]

Hi, I need to select data from a table in Oracle which is linked by dblink:

SELECT *

FROM "MYSCHEMA"."VIEW01@OTHER_SCHEMA";

When I try to reload script, it throws an Oracle error:

SQL Error:[Oracle][ODBC][Ora]ORA-00942: table or view doesn't exist

I'm trying to avoid the creation of more views inside MYSCHEMA.

Is that possible?

Thank you!

[#2 · Accepted solution]

Hi

first u make dsn then you could call that dsn in qvw file.

then connection string is generated.

now you can

SELECT *

FROM "MYSCHEMA". VIEW01@OTHER_SCHEMA;

Regards

Ashish

[#3]

Done, It worked. Thank you!