2

I've been playing qith QGIS Chugiak (2.4.0). I've been attempting to try to add Oracle Spatial tables (point, line and polygon feature classes) to desktop. The same tables I use in ArcGIS. I've managed to get the connection working using the instructions here but 2 things are happening:

  1. Not all tables in my database get populated
  2. When I expand out the the owner groups to get the list of tables, the tables are all greyed out.

I'm not sure why either of these things are happening. In the first issue, I can't see it being a permissions issue as I am logging into the Oracle connection with my Oracle credentials which is already tied to my Oracle account and thus, should grant table access so I'm not sure what's going on there.

In the second issue, I can't figure out why the tables are greyed out. I've tried setting a spatial reference under the SRID field, but that isn't working. Any suggestions?

EDIT:

I got this issue of the greyed out feature tables fixed. I set the SRID field to a relevant spatial reference and also, the 'Primary key column' needs to be populated as well. I used OBJECTID as that is the primary field in my feature classes. So, now I can add my feature classes. I am still having issues getting all of the tables populated. I have several hundred and only 7 of them are loading.

enter image description here

3

I had the same problem.Specify SRID as 4326 or something relevant.I am not sure QGIS cannot detect SRID automatically.

  • Thanks Durga. I got this issue of the greyed out feature tables fixed and it's exactly what you said. I set the SRID field to a relevant spatial reference and also, the 'Primary key column' needs to be populated as well. I used OBJECTID as that is the primary field in my feature classes. So, now I can add my feature classes. I am still having issues getting all of the tables populated. I have several hundred and only 7 of them are loading. I am going to update my original question with this inforamtion. – Mike Jan 20 '15 at 17:16

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.