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

Last updated on FEBRUARY 01, 2022

Applies to:

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

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