• Replies 7 replies
  • Subscribers 59 subscribers
  • Views 4230 views
  • Users 0 members are here

Only a few tables are visible through Oracle import

Krister Surell
Offline
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
  • Offline in reply to Jerry Walter - Bentley
    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

  • Offline

    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

     

Communities
Support and Services
Training and Learning
Social Media