Adding non-spatial Oracle table to QGIS

Question

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, Commented Jul 9, 2017 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, Commented Jul 9, 2017 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, Commented Jul 9, 2017 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, Commented Jul 10, 2017 at 11:55

enolan · Accepted Answer · 2017-07-11 16:00:48Z

2

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

answered Jul 11, 2017 at 16:00

enolan

6743 silver badges10 bronze badges

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
Commented Jul 11, 2017 at 19:26

Add a comment |

1 Answer 1