Dave Smith has been blogging about the issues with ST_Geometry on Oracle 10g.
Recently two ESRI customers have reported problems to ESRI Technical Support after upgrading to Oracle 10.2.0.4. The Oracle upgrade appears to be deleting some schema elements we require for the spatial type (ST_GEOMETRY). Uninstalling the upgrade to restore the prior version of Oracle [...]

