[mapguide-users] Oracle 11gR2 - Basics..
simon at sl-king.com
Thu Jan 26 10:05:49 EST 2012
Set your OracleSchema value to xxxx (you username or schema name where
table with geometry is stored)
OracleSchema : " xxxx "
Otherwise check USER_SDO_GEOM_METADATA view.
King.Oracle provider will read ALL_SDO_GEOM_METADATA View and find tables
and columns with SDO_GEOMETRY data type.
For each pair Table-Column King.Oracle will create an FDO Feature class.
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.
Check and Update/Insert statement for USER_SDO_GEOM_METADATA for your
INSERT INTO USER_SDO_GEOM_METADATA
MDSYS.SDO_DIM_ELEMENT('X', -180, 180, 0.000000005),
MDSYS.SDO_DIM_ELEMENT('Y', -90, 90, 0.000000005)
4326 -- SRID
You must also create Spatial index on that geometry.
On Thu, Jan 26, 2012 at 3:54 PM, Birgir <bgu at geograf.dk> wrote:
> Ive just installed Oracle 11gR2 and I need to....
> create a new table
> import data to that table
> show the data in Mapguide.
> So far I've been able to install Oracle, create the table and importing the
> data to that table.
> Im also able to create a feature source (with KingOracle) to my Oracle
> database with the following connection parameters:
> Username : xxxx
> Password : xxxx
> Service : xe
> OracleSchema : "empty"
> KindFdoClass : "empty"
> SDE Schema : "empty"
> But when I create a layer for my Oracle feature source, I recevie the
> following error message:
> "Feature Source (Library://.....) has no usable feature classes. Choose a
> different feature source."
> Does the error message mean that my database doesnt have a table with
> spatial context? if yes, what can I do to correct this?
> View this message in context:
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mapguide-users