Writer Overview
The Oracle Non-Spatial writer module stores attribute data in an Oracle database.
The Oracle Non-Spatial writer provides the following capabilities:
- Transaction Support: The Oracle Non-Spatial writer provides transaction support that eases the data loading process. Occasionally, a data load operation terminates prematurely due to data difficulties. The transaction support provides a mechanism for reloading corrected data without data loss or duplication.
- Table Creation: The Oracle Non-Spatial writer uses the information within the FME mapping file to automatically create database tables as needed.
- Table Dropping: The Oracle Non-Spatial writer has an option that allows each table to be written to be dropped if recreating, or truncated if appending.
- Index Creation: The Oracle Non-Spatial writer will set up and populate all needed indexes and index tables as part of the loading process.
- Bulk Loading: The Oracle Non-Spatial writer uses a bulk loading technique to ensure speedy data load.