Dbms2sde

Dbms2sde is a command-line utility (similar to ArcSDE Administrative Commands, e.g., sdelayer) written using ESRI’s ArcSDE API for the C programming language. It takes an existing business table in an RDBMS (e.g., Oracle) and spatially enables that table (or a copy of that table) in either standard ArcSDE (SDE_BINARY) or native SQL (e.g., Oracle Spatial / SDO_GEOMETRY) storage types.

Currently supported spatial feature types are points, lines, rectangles, quadrilaterals, and circles (I will do polygons next). Here are some examples...