[mapguide-users] View on Oracle Express

[VOLZ Mark (FN)]

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-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at 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 <fsozzi at 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 at 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 at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users









---------------------------------------------------------------------
To report this email as spam, please forward to spam at 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.desk at 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
*************************************************************************