Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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