QGIS access Oracle non-spatial database tables

Question

I stumbled accross this when I tried to connect to a "normal" Oracle 11g instance (no Oracle Spatial) in order to join Oracle tables to spatial data in other formats. Note that this is not about tables without geometry in an Oracle Spatial db (same issue with PostgreSQL db without PostGIS extension).
A related issue has already been addressed and answered in this question: Adding non-spatial Oracle table to QGIS
Unfortunately, the answer to the above question does not work for me, because the scan does not find MDSYS.SDO_GEOMETRY object.

I think that it is a common task to join non-spatial data from non-spatially enabled databases with spatial data of any source, so is there a way to access "normal" Oracle db (rsp. PostgreSQL or any other databases) without spatial extension or is this generally impossible from QGIS?

nr_aus · Answer

Also maybe have a read of this link.
Can QGIS use a non spatial oracle database?
The article talks about how MDSYS.SDO_GEOMETRY is standard, even in a non-Oracle Spatial database. Thats because its part of Oracle Locator, which is standard Oracle DB.
So possibly your Oracle database hasn't been setup properly? I would see if you can investigate checking if Oracle DB has the components installed with Oracle Locator.

QGIS access Oracle non-spatial database tables

One Answer

Add your own answers!

Ask a Question