Help running a Query in Oracle DB

I’m facing the following scenario:
I’m trying to make a database connection in Oracle to execute a query to a table.
I made the connection successfully to the DB, but when I try to execute the query it shows the following message: “ERROR [42S02] [Oracle][ODBC][Ora]ORA-00942: table or view does not exist”
I’m also attaching a image of my activity setup.

Thanks in advance for the advice.


Is the table or view exists in the master database?
If not explicitly mention the database name in the select query like below -

Select * from SourceDB.dbo.SourceTable

Karthik Byggari

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.