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?

Inactivated Account
19.1k5 gold badges72 silver badges117 bronze badges
asked Dec 7, 2020 at 14:59

1 Answer 1

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.

answered Dec 8, 2020 at 1:53

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.