Hi!<div><br></div><div>If you are using King Oracle Provider try using <b>KingFdoClass </b>table to populate view as FDO Class instead of inserting views in <span class="Apple-style-span" style="font-family: Arial; border-collapse: collapse; ">USER_SDO_GEOM_METADATA</span>.</div>
<div>Here are instruction on how to do this: <a href="http://www.sl-king.com/fdooracle/KingFdoClass.htm">http://www.sl-king.com/fdooracle/KingFdoClass.htm</a></div><div><br></div><div><br></div><div>Simon</div><span id="tekst-naslov"> <br>
</span><div>Instead "inserting" views in <span class="Apple-style-span" style="font-family: Arial; border-collapse: collapse; ">USER_SDO_GEOM_METADATA</span><span class="Apple-style-span" style="font-family: Arial; border-collapse: collapse; "> you can USE </span><br>
<br><div class="gmail_quote">On Tue, Sep 7, 2010 at 9:42 AM, Francesco Sozzi <span dir="ltr"><<a href="mailto:fsozzi@intercad.ch">fsozzi@intercad.ch</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi Mark,<br>
<br>
Thanks for answer.<br>
<br>
I confirm primary key and spatial index for both tables and views.<br>
On Oracle Express I manage small data. Tablespaces are smaller that 100MB.<br>
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.<br>
<br>
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.<br>
Please note that I need views (or these "side" tables) to show joined data in the property panel.<br>
<br>
Best regard<br>
<br>
Francesco<br>
<br>
<br>
----- Original Message ----- From: "VOLZ Mark (FN)" <<a href="mailto:Mark.Volz@ergon.com.au" target="_blank">Mark.Volz@ergon.com.au</a>><div class="im"><br>
To: "MapGuide Users Mail List" <<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a>><br></div>
Sent: Monday, September 06, 2010 8:00 PM<br>
Subject: RE: [mapguide-users] View on Oracle Express<div><div></div><div class="h5"><br>
<br>
<br>
Francesco,<br>
<br>
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?<br>
<br>
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.<br>
<br>
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.<br>
<br>
Mark<br>
<br>
<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a>] On Behalf Of Zac Spitzer<br>
Sent: Tuesday, 7 September 2010 11:27 AM<br>
To: MapGuide Users Mail List<br>
Subject: Re: [mapguide-users] View on Oracle Express<br>
<br>
have you tried the latest king oracle provider?<br>
<br>
<a href="http://www.sl-king.com/fdooracle/" target="_blank">http://www.sl-king.com/fdooracle/</a><br>
<br>
Also it's always helpful to state versions of the various software<br>
<br>
z<br>
<br>
On Mon, Sep 6, 2010 at 10:38 PM, Francesco Sozzi <<a href="mailto:fsozzi@intercad.ch" target="_blank">fsozzi@intercad.ch</a>> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi All,<br>
<br>
I have an Oracle schema with views to render on Mapguide Open Source.<br>
If I load this schema on an Oracle Standard or Enterprise, views are<br>
rendered.<br>
If I load on Mapguide from express, they are not rendered (I can<br>
render the table with geometry field, but not the view).<br>
<br>
All views are in USER_SDO_GEOM_METADATA and all views have primary keys.<br>
I can load and render on Autodesk Map from Oracle Express without problems.<br>
>From Maestro I can see them in the list, if I try to create a layer,<br>
but they are not rendered at all.<br>
<br>
Any idea or suggstions?....<br>
<br>
Best regards<br>
<br>
Francesco<br>
<br>
__________ Information from ESET NOD32 Antivirus, version of virus<br>
signature database 5426 (20100906) __________<br>
<br>
The message was checked by ESET NOD32 Antivirus.<br>
<br>
<a href="http://www.eset.com" target="_blank">http://www.eset.com</a><br>
<br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br>
<br>
</blockquote>
<br>
<br>
<br>
--<br>
Zac Spitzer<br>
Solution Architect / Director<br>
Ennoble Consultancy Australia<br>
<a href="http://www.ennoble.com.au" target="_blank">http://www.ennoble.com.au</a><br>
<a href="http://zacster.blogspot.com" target="_blank">http://zacster.blogspot.com</a><br>
+61 405 847 168<br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
---------------------------------------------------------------------<br>
To report this email as spam, please forward to <a href="mailto:spam@mailcontrol.com" target="_blank">spam@mailcontrol.com</a><br>
---------------------------------------------------------------------<br>
<br>
<br>
*************************************************************************<br>
This e-mail (including any attachments) may contain confidential or<br>
privileged information and is intended for the sole use of the person(s) to<br>
whom it is addressed. If you are not the intended recipient, or the person<br>
responsible for delivering this message to the intended recipient, please<br>
notify the sender of the message or send an e-mail to<br>
mailto:<a href="mailto:help.desk@ergon.com.au" target="_blank">help.desk@ergon.com.au</a> immediately, and delete all copies. Any<br>
unauthorised review, use, alteration, disclosure or distribution of this<br>
e-mail by an unintended recipient is prohibited. Ergon Energy accepts no<br>
responsibility for the content of any e-mail sent by an employee which is of<br>
a personal nature.<br>
<br>
Ergon Energy Corporation Limited ABN 50 087 646 062<br>
*************************************************************************<br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br></div></div>
__________ Information from ESET NOD32 Antivirus, version of virus signature database 5429 (20100906) __________<div class="im"><br>
<br>
The message was checked by ESET NOD32 Antivirus.<br>
<br>
<a href="http://www.eset.com" target="_blank">http://www.eset.com</a><br>
<br>
<br>
<br>
<br></div>
__________ Information from ESET NOD32 Antivirus, version of virus signature database 5429 (20100906) __________<div><div></div><div class="h5"><br>
<br>
The message was checked by ESET NOD32 Antivirus.<br>
<br>
<a href="http://www.eset.com" target="_blank">http://www.eset.com</a><br>
<br>
<br>
<br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</div></div></blockquote></div><br></div>