3

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.

enter image description here

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?

1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.