Help running a Query in Oracle DB

Help
1

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.

Image%20of%20Execute%20Query
Image%20of%20Execute%20Query949×474 44.7 KB

Thanks in advance for the advice.

Cesar

2

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

Regards,
Karthik Byggari

3

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