I was provided connection details to a non-spatial Oracle DB. I can create the connection (sde) file and see the list of tables, however if I right click on a table and choose Add To Current Map, I get the error:
Failed to add data: C:\Users\...\dbconnection.sde\SCHEMA.NAME. DBMS table not found[ORA-00942: table or view does not exist].
Strangely, I am able to use Python search cursor to traverse the table programmatically, and arcpy.TableToTable_conversion will successfully export the data to a local geodatabase. But what I want to do is add the table to a map so I can publish it to my ArcGIS Enterprise environment. (next step will be to register database as a datastore on Enterprise but this is the first step of course)
I have checked with the DBA, and seem to have the correct permissions (CREATE_SESSION and SELECT. Have also loaded the Oracle drivers (OracleDatabaseInstantClient19c) to my windows machine and added location to my path. Any ideas here what could be happening.
