Oracle Locator vs Spatial

Oracle Locator

Oracle Spatial

Free  included in oracle 10G onwards What Can Oracle Locator Do for You? Query nearest neighbor and other spatial relationships between geometries Perform location queries on relational information not stored in Oracle Spatial geometry Support long transactions Store and index vector geometries in the database Enhance application performance http://www.oracle.com/technology/products/spatial/pdf/10gr2_collateral/locator_twp_10gr2.pd

Additional option on top of oracle database What Can Oracle Spatial Do for You? Everything that Oracle Locator does, and: Perform length and area calculations on geometries Generate new geometries such as buffers and unions Perform coordinate systems transformations, for individual geometries or entire layers Store linear measure information http://www.oracle.com/technology/products/spatial/pdf/10gr2_collateral/spatial_twp_10gr2.pdf