I've got some questions I've collected as we try to come to a decision about whether to use ST_Geometry or SDE native geometry for an Oracle/SDE datastore on a new project. The organization has quite a few legacy systems that use the SDE Binary type, and this would be the first to use ST_Geometry if we went that route.
Apart from the ability to access spatial data in ArcSDE with SQL, what are the benefits and drawbacks of ST_Geometry?
What sort of pitfalls have you experienced in implementing with one type or the other?
Can more than one data type live in the same schema?
Note: for this project the data in SDE will be all points and polygons.