Hi!<div><br></div><div>Set your OracleSchema value to xxxx (you username or schema name where table with geometry is stored)</div><div><br></div><div>OracleSchema : "
xxxx "<br><br></div><div><br></div><div>Otherwise check <span style="background-color:rgb(255,255,255);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px">USER_SDO_GEOM_METADATA view.</span></div><div><span style="background-color:rgb(255,255,255);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px"><br>
</span></div><div><span style="font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgb(255,255,255)">King.Oracle provider will read ALL_SDO_GEOM_METADATA View and find tables and columns with SDO_GEOMETRY data type.</span></div>
<div><span style="font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgb(255,255,255)">For each pair Table-Column King.Oracle will create an FDO Feature class. </span></div><div><span style="font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px;background-color:rgb(255,255,255)">If you want a FDO Feature class to be created based on Oracle View than you need to add a row in USER_SDO_GEOM_METADATA for that View.</span></div>
<div><font face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size:12px"><br></span></font></div><div><p style="line-height:1.6em;font-family:arial,sans-serif;font-size:12px;background-color:rgb(255,255,255)">
<span style="line-height:1.6em">Check and Update/Insert statement for USER_SDO_GEOM_METADATA for your geometry</span></p><pre lang="SQL" style="font-size:12px;background-color:rgb(255,255,255)">INSERT INTO USER_SDO_GEOM_METADATA
VALUES(
'EVENTS','GEOM',
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT('X', -180, 180, 0.000000005),
MDSYS.SDO_DIM_ELEMENT('Y', -90, 90, 0.000000005)
),
4326 -- SRID
);
</pre><p style="line-height:1.6em;font-family:arial,sans-serif;font-size:12px;background-color:rgb(255,255,255)">You must also create Spatial index on that geometry.</p><p style="line-height:1.6em;font-family:arial,sans-serif;font-size:12px;background-color:rgb(255,255,255)">
<span style="line-height:1.6em">Regards,</span></p><p style="line-height:1.6em;font-family:arial,sans-serif;font-size:12px;background-color:rgb(255,255,255)"><span style="line-height:1.6em">Simon</span></p></div><div><font face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size:12px"><br>
</span></font></div><div><font face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size:12px"><br></span></font></div><div><font face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size:12px"><br></span></font><br>
<div class="gmail_quote">On Thu, Jan 26, 2012 at 3:54 PM, Birgir <span dir="ltr"><<a href="mailto:bgu@geograf.dk">bgu@geograf.dk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
Ive just installed Oracle 11gR2 and I need to....<br>
create a new table<br>
import data to that table<br>
show the data in Mapguide.<br>
<br>
So far I've been able to install Oracle, create the table and importing the<br>
data to that table.<br>
Im also able to create a feature source (with KingOracle) to my Oracle<br>
database with the following connection parameters:<br>
<br>
Username : xxxx<br>
Password : xxxx<br>
Service : xe<br>
OracleSchema : "empty"<br>
KindFdoClass : "empty"<br>
SDE Schema : "empty"<br>
<br>
But when I create a layer for my Oracle feature source, I recevie the<br>
following error message:<br>
"Feature Source (Library://.....) has no usable feature classes. Choose a<br>
different feature source."<br>
<br>
Does the error message mean that my database doesnt have a table with<br>
spatial context? if yes, what can I do to correct this?<br>
<br>
Regards,<br>
<span class="HOEnZb"><font color="#888888">Birgir<br>
<br>
--<br>
View this message in context: <a href="http://osgeo-org.1560.n6.nabble.com/Oracle-11gR2-Basics-tp4340841p4340841.html" target="_blank">http://osgeo-org.1560.n6.nabble.com/Oracle-11gR2-Basics-tp4340841p4340841.html</a><br>
Sent from the MapGuide Users mailing list archive at Nabble.com.<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>
</font></span></blockquote></div><br></div>