0

I can connect to Oracle database adding and creating spatial layer.

In the same database there are non-spatial tables but I cannot view any of them when connected to the database.

I need to add these tables to QGIS to perform joins with spatial layer.

How do I add non-spatial Oracle table to QGIS?

  • In fact, you don't need the tables in QGIS to join them to the table with SDO_GEOMETRY -- the database would do a JOIN way faster than QGIS could. If you create views you won't need to fashion queries in the GIS software. – Vince Jul 9 '17 at 14:11
  • thanks. some of these tables need to be joined with shape file, also there is standalone tables with .dbf extensions need to be added to qgis and I don't know how to add standalone table to qgis regarding its type I found tutorial to add CSV files only, I used Arcmap previously so may be I'm thinking in some matching point – Rawan Ahmad Jul 9 '17 at 14:26
  • Your comment has made this three totally different questions. We have a firm "One question per Question" policy, as stated in the Tour. Please focus on one question at a time. – Vince Jul 9 '17 at 21:43
  • I searched again finding some helpful posts like this one gis.stackexchange.com/questions/171399/… and I'm trying to create spatial views via oracle – Rawan Ahmad Jul 10 '17 at 11:55
0

Try checking "Also list tables with no geometry." And then let the scan run.

  • I don't know why someone rated this answer not useful. This is exactly how you add non-spatial tables from an Oracle spatial connection to QGIS... – enolan Jul 11 '17 at 19:26

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.