[mapguide-users] Import Views from Oracle Spatial

[Zac Spitzer]

try creating a spatial  index on the view

On Tue, Jul 29, 2008 at 12:59 AM, A. Fischer <deejot at gmx.de> wrote:
>
> Hello together,
>
> when I create a new Layer in MapGuide I can only select the tables from my
> database but not the views.
> Now I read here, that I have to insert the views into the
> user_sdo_geom_metadata - table:
>
> INSERT INTO user_SDO_GEOM_METADATA  VALUES ('VIEW_NAME',
> 'GEOM',SDO_DIM_ARRAY(
>    SDO_DIM_ELEMENT('X', -1000000, 1000000, 0.005),
>    SDO_DIM_ELEMENT('Y', -1000000, 1000000, 0.005)
>     )
> ,NULL)
>
> But I still can not select my VIEW from the list. Is there something else to
> do?
>
> I would be pleased to receive an answer.
> Kind regards, Alexander Fischer
> --
> View this message in context: http://www.nabble.com/Import-Views-from-Oracle-Spatial-tp18689745p18689745.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



-- 
Zac Spitzer -
http://zacster.blogspot.com (My Blog)
+61 405 847 168