This product works directly with Oracle Spatial data including support for Oracle 10g, 11g, and 12c database servers. Take note of the following:

• To access a 12c database, the Oracle 11g or 12c client must be installed.

• To access a 11g database, the Oracle 11g or 12c client must be installed.

• To access a 10g database, the Oracle 11g or 12c client must be installed.

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.

  To determine if a table contains more than one geometry type, SQL > select p.geometry.sdo_gtype, count(*) from your_table p group by p.geometry.sdo_gtype;

  GTYPE = 2001 = points

  GTYPE = 2002 = lines

  GTYPE = 2003 = polygons