I have an Esri Enterprise Geodatabase (ArcSDE 10.2.2; Oracle 10G).

I am trying to connect it with QGIS 2.16.

So I clicked "Add vector layer" button with "Database" Type : Oracle Spatial (I've tried with "ESRI Personal GeDatabase) I filled the parameters of the connection.

I clicked "Test" button -> connection successful

When I click OK I've got this message :

Invalid Data Source: OCI:admin/[email protected]:1522/psigdat is not a valid or recognized data source

Can anybody help me ?

  • 1
    Try Add Layer >Oracle Spatial rather than vector layer database they use different drivers to retrieve the data
    – Mapperz
    Oct 18, 2016 at 15:08
  • Thanks for your response. When I use "Oracle Spatial Layer", I've some system tables appatenant au USER MDSYS, even if i'm not connected with. Layers are for exemple : ALL_SDO_INDEX_METADATA ALL_SDO_STYLES CS_SRS DBA_SDO_STYLES etc. I use ST_GEOMETRY and not SDO_GEOMETRY. Could it be a reason ?
    – SA_gis
    Oct 18, 2016 at 15:36
  • This is not an answer. Please edit your question and move this information there and delete this answer.
    – kttii
    Oct 18, 2016 at 17:39
  • tick the 'only look in user's table' for your tables on the create A New Oracle connection'
    – Mapperz
    Oct 18, 2016 at 19:03

2 Answers 2


The is comment with an image enter image description here

To get to your own tables using QGIS and the Oracle Spatial Tables use these settings

  • So i didn't see any table of my user.
    – SA_gis
    Oct 19, 2016 at 6:40

The solution is to stock data in SDO_GEOMETRY and no ST_GEOMETRY.


Bad news for me.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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