English

FAQ: Is SDO_GEOMETRY supported with ArcSDE 9.0 on Oracle Standard Edition?

Question

Is SDO_GEOMETRY supported with ArcSDE 9.0 on Oracle Standard Edition?

Answer

Yes, it is.

The following note appears in the ArcSDE 9.0 Installation Guide for
Windows:

"Note: Geometry storage with Oracle Standard Edition is limited to Long Raw (ArcSDE default) or LOB types."

This information is incorrect. Oracle Locator is available on Oracle 9i Standard Edition. Therefore, ArcSDE for this platform can store geometries in the SDO_GEOMETRY data type.

This note does not appear in the ArcSDE 9.0 Installation Guide for Unix.