A materialized view might need its own primary key defined as it's basically a table.
Dave -----Original Message----- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of GordonL Sent: Tuesday, May 26, 2009 2:37 PM To: mapguide-users@lists.osgeo.org Subject: RE: [mapguide-users] Oracle FDO and View Yes, it does work, but it does not allow me to select features in the map. For example, I have a materialize view called MVIEW_PARCELS, it has a spatial index on the GEOMETRY column and index on the GIS_ID column. It has a row in the MDSYS.SDO_GEOM_METADATA_TABLE. I can see everything on the map in MapGuide, but I cannot select individual parcels. gordon Dave Wilson wrote: > > Actually you can use a view if it includes the primary key column from the > underlying geometry table. You also have to add user_sdo_geom_metadata > records for the view. Basically insert by copying the entry for the > underlying table that has the geometry. > > It should work without the materialized view. > > At least it does with the Autodesk Oracle provider. > > Dave > > -----Original Message----- > From: mapguide-users-boun...@lists.osgeo.org > [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of David Hequet > Sent: Wednesday, May 20, 2009 7:24 AM > To: mapguide-users@lists.osgeo.org > Subject: RE: [mapguide-users] Oracle FDO and View > > > With Oracle you can add primary key (don't confuse index and Key) to view > (sorry i don't have the sql here). > > Materialized view is a good way to improve performance (espacially if you > use view on multiple database). > > > Haris Kurtagic wrote: >> >> Yes, you need to create materialized view for index or you can use >> KingFdoClass metadata table to tell provider which column will be used >> as primary key. >> >> Haris >> >> -----Original Message----- >> From: mapguide-users-boun...@lists.osgeo.org >> [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of GordonL >> Sent: Wednesday, May 20, 2009 3:05 PM >> To: mapguide-users@lists.osgeo.org >> Subject: Re: [mapguide-users] Oracle FDO and View >> >> >> Thanks David, >> Index on a view? The core tables are already indexed - including the >> GEOMETRY column. Do you mean convert it to a MATERIALIZED VIEW and >> index it >> then? >> >> thanks >> gordon >> >> >> >> David Hequet wrote: >>> >>> Hi, >>> >>> Features can be selectable if you add primary key to your view >> (MapGuide >>> need Primary key on all feature to be selectable). >>> >>> David >>> >>> >>> GordonL wrote: >>>> >>>> Hi David, did you ever solve this problem? >>>> >>>> I am having trouble that features drawn from VIEWS in Oracle are not >>>> selectable (FDO 4.3). This is true for both the Autodesk Oracle >> Provider >>>> AND the KING one.. >>>> >>>> thanks >>>> gordon >>>> >>>> >>>> David Hequet wrote: >>>>> >>>>> Hello, >>>>> >>>>> About this case i'm using Autodesk Mapguide Enterprise 2008 with >>>>> Autodesk Spatial Oracle FDO. >>>>> One of the new feature is "using Oracle View" >>>>> I tried to use a view with geometry, it work, but features can't be >>>>> selectable! I make them selectable in Studio but they are not, >> either in >>>>> dwf or ajax viewer. >>>>> >>>>> Is it the same with the Oracle King provider? Or anyone has an idea >> on >>>>> how make them selectable (really :p ) >>>>> >>>> >>>> >>> >>> >> >> -- >> View this message in context: >> http://n2.nabble.com/Oracle-FDO-and-View-tp1811392p2946000.html >> Sent from the MapGuide Users mailing list archive at Nabble.com. >> >> _______________________________________________ >> mapguide-users mailing list >> mapguide-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> _______________________________________________ >> mapguide-users mailing list >> mapguide-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> > > -- > View this message in context: > http://n2.nabble.com/Oracle-FDO-and-View-tp1811392p2946099.html > Sent from the MapGuide Users mailing list archive at Nabble.com. > > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- View this message in context: http://n2.nabble.com/Oracle-FDO-and-View-tp1811392p2977086.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
