From Oracle FAQ
Jump to: navigation, search

Oracle Locator is a scaled down "free" version of Oracle Spatial.

Functionality provided[edit]

Locator includes the data types, operators, and indexing capabilities of Oracle Spatial, along with a limited set of the functions and procedures of Spatial. The Locator features include the following:

  • An object type (SDO_GEOMETRY) that describes and supports any type of geometry
  • A spatial indexing capability that lets you create spatial indexes on geometry data
  • Spatial operators that use the spatial index for performing spatial queries
  • Some geometry functions and the SDO_AGGR_MBR spatial aggregate function
  • An object type that describes and supports geometries such as points, lines, polygons
  • Fast spatial R-tree indexing
  • Spatial operators that use the spatial index for performing queries that determine the interaction of geometric features
  • Spatial functions for distance, area, and length
  • Spatial function for buffering (new to Locator in release 11g)
  • Open, standard SQL access to spatial operations
  • Whole Earth geometry model that provides comprehensive storage, management and use of geodetic data
  • Function-based spatial indexes
  • Long transactions (through Oracle Workspace Manager feature)
  • Coordinate system support based on the European Petroleum Survey Group (EPSG) data model
  • Explicit coordinate transformations
  • Support for SQL/MM Spatial types and operators** (new to Locator in release 11g)
  • Tuning functions and procedures (SDO_TUNE package)
  • Spatial utility functions (SDO_UTIL package)
  • Integration with Oracle Application Server MapViewer


Locator is provided free of charge with Oracle Enterprise Edition, Standard Edition (SE & SE1) and Oracle XE.

Also see[edit]

  • Spatial - Database option for advanced Spatial functionality
  • Mapviewer - Oracle's map rendering solution