I'm trying make a query layer using tabular information in an Oracle database and a parcel centriod point file. The SQL query I'm using is not working and the error seems like the oracle table is not being found.
Attached is my SQL statement and error message
You are trying to join tables that are not only in different databases, but different DBMSes. Although doing such a query is possible in the DBMS realm, it requires linked servers to be configured correctly. Are you sure either the Oracle or SQL Server database is configured correctly to support a database link to the other?
I now understand that we need to setup the linked Oracle DB to create a view with the two databases.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
