Hi! If you are using King Oracle Provider try using *KingFdoClass *table to populate view as FDO Class instead of inserting views in USER_SDO_GEOM_METADATA. Here are instruction on how to do this: http://www.sl-king.com/fdooracle/KingFdoClass.htm
Simon Instead "inserting" views in USER_SDO_GEOM_METADATA you can USE On Tue, Sep 7, 2010 at 9:42 AM, Francesco Sozzi <fso...@intercad.ch> wrote: > Hi Mark, > > Thanks for answer. > > I confirm primary key and spatial index for both tables and views. > On Oracle Express I manage small data. Tablespaces are smaller that 100MB. > I tried to drop and recreate all keys and spatial index. Oracle did the job > with no warnings or errors, so I am sure all index are ok. > > For the moment my workaround is to create side tables with the content of > views, a sort of snapshots on views I need to publish data. With these > tables (populated with data from views) MG works as expected. > Please note that I need views (or these "side" tables) to show joined data > in the property panel. > > Best regard > > Francesco > > > ----- Original Message ----- From: "VOLZ Mark (FN)" < > mark.v...@ergon.com.au> > > To: "MapGuide Users Mail List" <mapguide-users@lists.osgeo.org> > Sent: Monday, September 06, 2010 8:00 PM > Subject: RE: [mapguide-users] View on Oracle Express > > > > Francesco, > > Can you confirm that the geometry columns (in the underlying table(s)) you > are trying to use in the views have a spatial index built on them? > > The second thing to look at is the size of the database. A spatial index > takes up table space so if you have a data set of about 4.5gb and then try > and build a spatial index it will fail due to the size restriction on XE. > This may be why the imported schema works in Standard/enterprise but not in > XE. > > Mapguide always sends a spatial query when querying the data from oracle > (which will fail if you don't have a spatial index), Autocad map doesn't > always do this. > > Mark > > > > -----Original Message----- > From: mapguide-users-boun...@lists.osgeo.org [mailto: > mapguide-users-boun...@lists.osgeo.org] On Behalf Of Zac Spitzer > Sent: Tuesday, 7 September 2010 11:27 AM > To: MapGuide Users Mail List > Subject: Re: [mapguide-users] View on Oracle Express > > have you tried the latest king oracle provider? > > http://www.sl-king.com/fdooracle/ > > Also it's always helpful to state versions of the various software > > z > > On Mon, Sep 6, 2010 at 10:38 PM, Francesco Sozzi <fso...@intercad.ch> > wrote: > >> Hi All, >> >> I have an Oracle schema with views to render on Mapguide Open Source. >> If I load this schema on an Oracle Standard or Enterprise, views are >> rendered. >> If I load on Mapguide from express, they are not rendered (I can >> render the table with geometry field, but not the view). >> >> All views are in USER_SDO_GEOM_METADATA and all views have primary keys. >> I can load and render on Autodesk Map from Oracle Express without >> problems. >> From Maestro I can see them in the list, if I try to create a layer, >> but they are not rendered at all. >> >> Any idea or suggstions?.... >> >> Best regards >> >> Francesco >> >> __________ Information from ESET NOD32 Antivirus, version of virus >> signature database 5426 (20100906) __________ >> >> The message was checked by ESET NOD32 Antivirus. >> >> http://www.eset.com >> >> _______________________________________________ >> mapguide-users mailing list >> mapguide-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> >> > > > -- > Zac Spitzer > Solution Architect / Director > Ennoble Consultancy Australia > http://www.ennoble.com.au > http://zacster.blogspot.com > +61 405 847 168 > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > > > > > > > > > --------------------------------------------------------------------- > To report this email as spam, please forward to s...@mailcontrol.com > --------------------------------------------------------------------- > > > ************************************************************************* > This e-mail (including any attachments) may contain confidential or > privileged information and is intended for the sole use of the person(s) to > whom it is addressed. If you are not the intended recipient, or the person > responsible for delivering this message to the intended recipient, please > notify the sender of the message or send an e-mail to > mailto:help.d...@ergon.com.au immediately, and delete all copies. Any > unauthorised review, use, alteration, disclosure or distribution of this > e-mail by an unintended recipient is prohibited. Ergon Energy accepts no > responsibility for the content of any e-mail sent by an employee which is > of > a personal nature. > > Ergon Energy Corporation Limited ABN 50 087 646 062 > ************************************************************************* > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 5429 (20100906) __________ > > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 5429 (20100906) __________ > > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.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