1

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 ?

Improve this question
4
  • 1
    Try Add Layer >Oracle Spatial rather than vector layer database they use different drivers to retrieve the data
    – Mapperz ♦
    Commented 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
    Commented 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
    Commented 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 ♦
    Commented Oct 18, 2016 at 19:03

2 Answers 2

Reset to default
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

Improve this answer
1
  • So i didn't see any table of my user.
    – SA_gis
    Commented Oct 19, 2016 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.

Improve this answer

Your Answer

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

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