Only a few tables are visible through Oracle import

Hi, I try to import data from Oracle Spatial but only a few of my tables turns up. The all have one geometry column, one geometry type, spatial indexes with a specified geometry type. It seems that only the tables with a simple primary key (one column) are visable. Is that the case or could it be anything else that filters out some tables? Regards, Krister Surell
  • Hi, So this is true even if I only want to read the data? In good old GeoGraphics (and SpatialViewer) I could read data from any table as long as I didn't need to post it back to Oracle. If this is the case this is a major problem for me, I and guess lots of others. Bentley Map shouldn't restrict my data model, it should adapt to it. Regards, Krister

    Owner consultant at Surell Consulting AB

  • K; 

    I believe you are real close.

     

    Here are the requirements for the SelectSeries1 version.

     

    In order for an Oracle table to be recognized as a feature, the following criteria must also be met:

    • The feature table must have a primary key constraint consisting of a single numeric or string/character column to represent the feature ID. This primary key is required to enable versioning using the standard versioning system of the Oracle Workspace Manager.
    • The table must have a geometric (SDO_GEOMETRY) column specifying the feature geometry, and this geometry column must be registered in the Oracle Spatial metadata table (ALL_SDO_GEOM_METADATA or the related USER_SDO_GEOM_METADATA view for the user).
    • The table fields must be of a common type, not a user defined type.
    • Geometry must be of similar types, meaning all geometries must be of point, line, or polygon type, not a mixture of these.

     

    HTH

    Jerry