SDO_GEOMETRY
Description
The geometric description of a spatial object is stored in a single row, in a single column of object type SDO_GEOMETRY in a user-defined table. Any table that has a column of type SDO_GEOMETRY must have another column, or set of columns, that defines a unique primary key for that table. (Oracle SQL Language Reference SDO_GEOMETRY Data Type)
Definition of SDO_GEOMETRY object:
The SDO_GEOMETRY
object is not supported in Snowflake. A workaround for this data type is to use Snowflake GEOGRAPHY, however that transformation is currently not supported by SnowConvert.
Sample Source Patterns
SDO_GEOMETRY in Create Table
Oracle
Snowflake
Inserting data in SDO_GEOMETRY Table
Oracle
Snowflake
Migration using the GEOGRAPHY data type
Oracle
Snowflake
Related EWIs
SSC-EWI-0073: Pending Functional Equivalence Review.
Last updated