Oracle8(TM) Server Spatial Cartridge User's Guide and Reference
Release 8.0.3
A53264_01

Contents

Title and Copyright Information

Preface

1 Spatial Cartridge Concepts

1.1 Introduction to Spatial Data

1.2 Geometric Types

1.4 Database Structures

1.5 Indexing Method

1.6 Partitioned Point Data

2 Loading Spatial Data

2.2 Loading Process

2.2.1 Bulk Loading

2.2.2 Transactional Insert Using SQL

2.2.3 Transactional Insert Using Spatial Geometry Functions

2.3 Index Creation

2.3.1 Indexing with Fixed-Size Tiles

3 Querying Spatial Data

3.1 Query Model

3.2 Spatial Data Model

3.3 Spatial Query

3.3.1 Dynamic Query Window

3.3.2 Primary Filter

3.3.3 Secondary Filter

3.4 Spatial Join

4 Partitioned Point Data

4.2 Partitioning Process

4.3 Function Details

5 Administrative Procedures

SDO_ADMIN.ALTER_HIGH_WATER_MARK

SDO_ADMIN.DROP_PARTITION_INFO

SDO_ADMIN.PARTITION

SDO_ADMIN.POPULATE_INDEX

SDO_ADMIN.POPULATE_INDEX_FIXED

SDO_ADMIN.PROPAGATE_GRANTS

SDO_ADMIN.REGISTER_PARTITION_INFO

SDO_ADMIN.REPARTITION

SDO_ADMIN.SDO_CODE_SIZE

SDO_ADMIN.UPDATE_INDEX

SDO_ADMIN.UPDATE_INDEX_FIXED

SDO_ADMIN.VERIFY_LAYER

SDO_ADMIN.VERIFY_PARTITIONS

6 Geometry Functions

SDO_GEOM.ADD_NODES

SDO_GEOM.INIT_ELEMENT

SDO_GEOM.INTERACT

SDO_GEOM.RELATE

SDO_GEOM.VALIDATE_GEOMETRY

7 Window Functions

SDO_WINDOW.BUILD_WINDOW

SDO_WINDOW.BUILD_WINDOW_FIXED

SDO_WINDOW.CLEAN_WINDOW

SDO_WINDOW.CREATE_WINDOW_LAYER

8 Partitioned Point Data Functions

SDO_BVALUETODIM

A Sample SQL Scripts

A.1 altpart.sql Script

A.2 cr_spatial_index.sql Script

A.3 crlayer.sql Script

A.4 droppart.sql Script

A.5 sdogrant.sql Script

B Data Dictionary

C Messages and Codes

D Last Supported Releases

D.1 SD*SQL Kernel Functions

D.2 SD*SQL Packages

E Unsupported Functions

Glossary

Index

Copyright © 1997 Oracle Corporation.
All Rights Reserved.