Edit D:\app\Administrator\product\11.2.0\dbhome_1\relnotes\readmes\README_LOCATOR.doc
Locator in Oracle 11gR2 (11.2.0.1.0 Production) ================================================= Note: For Oracle8i, LOCATOR_WITHIN_DISTANCE was the only Locator operator supported. For Oracle9i, LOCATOR_WITHIN_DISTANCE and SDO_WITHIN_DISTANCE are synonyms (same signatures and behavior), and both are supported. For information about spatial concepts, the SDO_GEOMETRY object type, and loading and indexing spatial data, see Chapters 1 through 4 in the Oracle Spatial User's Guide and Reference. For reference and usage information about features supported by Locator, see the following chapters in that manual. Chapter Supported Locator Features Chapter 7 Geocoding Chapter 9 SQL statements for creating, altering, and deleting indexes Chapter 10 SDO_GEOMETRY object type methods Chapter 11 Spatial operators Migrating from Oracle 8i Locator =============================== There is a new geodetic computational model in 9i which adds new functionality to Locator. For this reason, the following procedure is required for upgrading all 8i locator data (all tables with sdo_geometry columns created and used by Locator): (0) First migrate the install to 9i. (i) Identify the Spatial indexes on these tables and drop them. (ii) Update all the data (point-ony in 8i) and add an SRID to the geometry. This SRID should be set to 8307. (iii) Update the user_sdo_geom_metadata to include the SRID=8307 for all locator related tables. (iv) Recreate the index using the R-tree indexing method. See the Spatial User's Guide and Reference for more details on how to performs these steps.
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de