You are here: FME Readers and Writers > Oracle Spatial Object Reader/Writer

Oracle Spatial Object Reader/Writer

Licensing options for reading this format begin with FME Professional edition. Licensing options for writing this format begin with FME Database edition.

Format Notes

Object Writing

Object writing is available only with these FME Editions: Oracle, DB2, Smallworld, and Server

Raster Support

Raster writing is available only with FME Database Edition

Raster data is supported only for Oracle 10g and above.

3D Geometry Support

Reading and writing of 3D surfaces and solids is available only for Oracle 11g and above.

Point Cloud Support

Reading and writing of point clouds is available only for Oracle 11g and above.

Oracle Instant Client

Instant Client can be used to run your OCI, OCCI, JDBC, and ODBC applications without installing a full Oracle Client. Instant Client supports SQL*Plus.

For more information on how it works with FME, see

http://fmepedia.safe.com/articles/FAQ/How-to-setup-an-Oracle-Instant-Client-for-use-with-FME.

Oracle Wallet

To use an Oracle Wallet with FME, leave the USER_NAME and PASSWORD directives empty, and enter the name of the Oracle Wallet as the Reader Dataset (ORACLE_DATASET).

Overview

The Oracle Spatial Reader/Writer module enables FME to read and write geometric, raster, point cloud, and attribute data stored using Oracle Spatial. This module communicates directly with Oracle Spatial for maximum throughput. Both the relational and object-relational models of Oracle Spatial are supported by FME: the object-relational model is discussed here and the relational model is discussed in a separate chapter – Oracle Spatial Relational Reader/Writer. The object-relational model is often referred to as simply the object model, to prevent confusion with the pure relational model.

Raster and point cloud reading and writing are handled by unique readers and writers, but are covered in this documentation chapter.

If only attributes are to be read or written, the FME Oracle Non-Spatial reader and writer module should be used.

This section assumes familiarity with Oracle Spatial, the geometry types it supports, its indexing mechanisms and raster and point cloud components.

Tip: The FeatureReader transformer performs queries against any FME-supported format.