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

1 Answer 1


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

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.