<div dir="ltr">I tried all. First I used SqlSheet for giving the views a primary key and/or a spatial index but both is not allowed to a View.<br>Also I downloaded fdo2fdo but I didn't get a connection to my database with this although it works with MapGuide Maestro and I used the same settings.<br>
But fdo2fdo gives the error "ORA-12154: TNS: could not resolve the connect identifier specified"<br><br><div class="gmail_quote">2008/7/29 Zac Spitzer <span dir="ltr"><<a href="mailto:zac.spitzer@gmail.com">zac.spitzer@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">try creating a spatial index on the view<br>
<div><div></div><div class="Wj3C7c"><br>
On Tue, Jul 29, 2008 at 12:59 AM, A. Fischer <<a href="mailto:deejot@gmx.de">deejot@gmx.de</a>> wrote:<br>
><br>
> Hello together,<br>
><br>
> when I create a new Layer in MapGuide I can only select the tables from my<br>
> database but not the views.<br>
> Now I read here, that I have to insert the views into the<br>
> user_sdo_geom_metadata - table:<br>
><br>
> INSERT INTO user_SDO_GEOM_METADATA VALUES ('VIEW_NAME',<br>
> 'GEOM',SDO_DIM_ARRAY(<br>
> SDO_DIM_ELEMENT('X', -1000000, 1000000, 0.005),<br>
> SDO_DIM_ELEMENT('Y', -1000000, 1000000, 0.005)<br>
> )<br>
> ,NULL)<br>
><br>
> But I still can not select my VIEW from the list. Is there something else to<br>
> do?<br>
><br>
> I would be pleased to receive an answer.<br>
> Kind regards, Alexander Fischer<br>
> --<br>
> View this message in context: <a href="http://www.nabble.com/Import-Views-from-Oracle-Spatial-tp18689745p18689745.html" target="_blank">http://www.nabble.com/Import-Views-from-Oracle-Spatial-tp18689745p18689745.html</a><br>
> Sent from the MapGuide Users mailing list archive at Nabble.com.<br>
><br>
> _______________________________________________<br>
> mapguide-users mailing list<br>
> <a href="mailto:mapguide-users@lists.osgeo.org">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>
</div></div><font color="#888888">--<br>
Zac Spitzer -<br>
<a href="http://zacster.blogspot.com" target="_blank">http://zacster.blogspot.com</a> (My Blog)<br>
+61 405 847 168<br>
</font><div><div></div><div class="Wj3C7c">_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">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></blockquote></div><br></div>