Along the same vein, I have an oracle view with coordinates (lat and lon) but
no spatial column. I can't add a row to user_sdo_geom_metadata (no spatial
column to "register"). I'm guessing I am out of luck here...
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/QGIS-and-Ora
ubject: Re: [Qgis-user] QGIS and Oracle Views
On 16-10-14 11:29, Jonathan Moules wrote:
> Has anyone else had success pointing to Oracle Views? How about PostGIS
> views, do they work?
hi Jonathan,
tried it here.
I'm able to see an Oracle View, but only after:
- create a simple (po
On 16-10-14 11:29, Jonathan Moules wrote:
> Has anyone else had success pointing to Oracle Views? How about PostGIS
> views, do they work?
hi Jonathan,
tried it here.
I'm able to see an Oracle View, but only after:
- create a simple (point view) via 'create view as select * from )
at tha
.osgeo.org] On Behalf Of Rob L
Sent: Tuesday, October 14, 2014 8:25 AM
To: qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] QGIS and Oracle Views
Jonathan,
I think as long as the view is registered in the `USER_SDO_GEOM_METADATA` table
then you should be able to add them in QGIS.
Think at the &quo
Jonathan,
I think as long as the view is registered in the `USER_SDO_GEOM_METADATA`
table then you should be able to add them in QGIS.
Think at the "Add Oracle Table(s)" dialog you just have to select a geometry
"Type" and a "Primary key column" using the drop downs.
Let me know how you get on.
Hi List,
I'm trying to get QGIS to connect to an Oracle View but as best I can tell QGIS
is requiring a Primary key. The problem is that I don't believe Oracle formally
supports these for views, only base tables or materialised views, and creating
one isn't necessarily that easy.
Is it possible
