My Oracle Support Banner

OWB 11.2.0.3 New Feature - Preprocessor in External Table (Doc ID 1347541.1)

Last updated on MAY 05, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.3 and later
Information in this document applies to any platform.

Purpose

This document describes the new OWB 11.2.0.3 feature for External Tables: it is about enhancing External Table support in Oracle Warehouse Builder so as to support the use of preprocessor in External Table.

An External Table is a table whose metadata is stored in the database but whose data is stored in files outside the database. The database uses the metadata describing external tables to expose their data as if they were relational tables.

External tables can be preprocessed by user-supplied preprocessor programs. By using a preprocessing program, users can use data from a file that is not in a format supported by the driver. For example, a user may want to access data stored in a compressed format. Specifying a decompression program for the ORACLE_LOADER access driver allows the data to be decompressed as the access driver processes the data.

Scope

OWB 11.2.0.3 and higher

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.