1

I've an ESRI Entrerprise gdb (Oracle 10G).

I'm 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/admin@dbpsigdat.nimes.fr: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 '16 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 '16 at 15:36
  • This is not an answer. Please edit your question and move this information there and delete this answer. – kttii Oct 18 '16 at 17:39
  • tick the 'only look in user's table' for your tables on the create A New Oracle connection' – Mapperz Oct 18 '16 at 19:03
1

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 '16 at 6:40
1

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

ST_GEOMETRY to SDO_GEOMETRY

Bad news for me.

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.