Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to call a table with oracle dblink

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!

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

2 Replies
Not applicable
Author

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

Not applicable
Author

Done, It worked. Thank you!