Oracle Spatial User's Guide and Reference
Release 9.0.1

Part Number A88805-01


Book List



Master Index


Go to previous page Go to next page


The Oracle Spatial User's Guide and Reference provides usage and reference information for indexing and storing spatial data and for developing spatial applications.

Spatial requires Oracle9i Enterprise Edition. Oracle9i and Oracle9i Enterprise Edition have the same basic features. However, several advanced features, such as extended data types, are available only with the Enterprise Edition, and some of these features are optional. For example, to use Oracle9i table partitioning, you must have the Enterprise Edition and the Partitioning Option.

For information about the differences between Oracle9i and Oracle9i Enterprise Edition and the features and options that are available to you, see Oracle9i Database New Features.


This is the last release of Oracle Spatial that will support the relational geometry model; only the object-relational model will be supported in Oracle9i release 2. Information about the relational model has been removed from this guide and placed in a separate manual, Oracle Spatial Relational Model Guide and Reference, which is available on the Oracle Technology Network.

If you have not already switched completely to the object-relational model, you should do so immediately. 


This guide is intended for anyone who needs to store spatial data in an Oracle database.


This guide has two main parts (conceptual and usage information, and reference information) and several appendixes with supplementary information. The first part is organized for efficient learning about Oracle Spatial; it covers basic concepts and techniques first, and proceeds to more advanced material (such as coordinate systems, the linear referencing system, geocoding, and extending spatial indexing).

This guide has the following elements.

Part I 

Conceptual and Usage Information 

Chapter 1 

Introduces spatial data concepts. 

Chapter 2 

Explains the object-relational schema. 

Chapter 3 

Explains how to load spatial data. 

Chapter 4 

Explains how to index and query spatial data. 

Chapter 5 

Provides detailed information about coordinate system (spatial reference system) support. 

Chapter 6 

Provides conceptual and usage information for using the Oracle Spatial linear referencing system (LRS). 

Chapter 7 

Describes the Spatial Generic Geocoding Interface. 

Chapter 8 

Explains how to extend the capabilities of Oracle Spatial indexing. 

Part II 

Reference Information 

Chapter 9 

Provides the syntax and semantics for SQL indexing statements. 

Chapter 10 

Provides the syntax and semantics for methods used with the spatial object data type. 

Chapter 11 

Provides the syntax and semantics for operators used with the spatial object data type. 

Chapter 12 

Provides the syntax and semantics for the geometric functions and procedures. 

Chapter 13 

Provides the syntax and semantics for the spatial aggregate functions. 

Chapter 14 

Provides the syntax and semantics for the coordinate system transformation functions. 

Chapter 15 

Provides the syntax and semantics for the linear referencing (LRS) functions. 

Chapter 16 

Provides the syntax and semantics for the migration functions. 

Chapter 17 

Provides the syntax and semantics for the tuning functions and procedures. 


Supplementary Information 

Appendix A 

Describes installation, compatibility, and migration issues. 

Appendix B 

Describes hybrid indexing. 

Appendix C 

Describes Oracle9i Locator. 





Changes for Release 9.0.1

The following are the main changes to this guide for this release:

Technologies Released Separately

Technologies of interest to spatial application developers, but not officially part of Oracle Spatial, are sometimes made available through the Oracle Technology Network (OTN). To access the OTN, go to

Related Documents

For more information, see the following documents:

For additional information about Oracle Spatial, including white papers and other collateral, go to

and search for Spatial.


In examples, an implied carriage return occurs at the end of each line, unless otherwise noted. You must press the Return key at the end of a line of input.

The following conventions are used in this guide:

Convention  Meaning 


Vertical ellipsis points in an example mean that information not directly related to the example has been omitted. 

. . .  

Horizontal ellipsis points in statements or commands mean that parts of the statement or command not directly related to the example have been omitted 

boldface text 

Boldface text indicates a term defined in the text, the glossary, or in both locations. 

< >  

Angle brackets enclose user-supplied names. 

[ ]  

Brackets enclose optional clauses from which you can choose one or none. 


The percent sign represents the system prompt on a UNIX system.  

Documentation Accessibility

Oracle's goal is to make our products, services, and supporting documentation accessible to the disabled community with good usability. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at

Accessibility of Code Examples in Documentation

JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.

Go to previous page Go to next page
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.


Book List



Master Index