[mapguide-users] View on Oracle Express

VOLZ Mark (FN) Mark.Volz at ergon.com.au
Wed Sep 8 00:30:33 EDT 2010


Francesco,

That all seems very strange (that it is working on tables but not
views). Are you changing the geometry in anyway in your views? i.e. are
you using any of cs_transform, aggr, sdo functions/procedures, custom
packages/functions/procedures, etc? certain ones will null and void your
index.

Are the entries in your user_sdo_geom_metadata for your views exactly
the same as the ones for the tables i.e. you haven't changed accuracies
or x & y column names.

Have your tried running a sdo_relate query on your view, shown below (it
will test the above questions)?
Select *
>From xe.view v
Where sdo_relate (v.geomtry_column,
sdo_geometry(2003,8311,null,sdo_elem_info_array(1,1003,3),sdo_ordinate_a
rray(145.683622,-16.88905,145.6925,-16.880274)), 'mask=ANYINTERACT') =
'TRUE';

Unless you are in Australia that code shouldn't return any records but
it will test that your view supports spatial queries (its actually a
snippet of sql that Mapguide sent to our database about 5 minutes ago).

Have you tried materialized view?

How did you add the primary key to the view? Did you use a statement
similar to this after creating the view;?
ALTER VIEW XE.VIEW ADD (
  CONSTRAINT VIEW_PK
 PRIMARY KEY
 (column_name) DISABLE);


Sorry if I am asking you to check simple things but I had similar
problems getting my oracle setup going so I'm just running through all
the different problems I ran into using views in XE and mapguide.

Mark.

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Francesco
Sozzi
Sent: Tuesday, 7 September 2010 5:42 PM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] View on Oracle Express

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.Volz at ergon.com.au>
To: "MapGuide Users Mail List" <mapguide-users at 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-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
************************************************************************
*
_______________________________________________
mapguide-users mailing list
mapguide-users at 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 at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users


More information about the mapguide-users mailing list