My Oracle Support Banner

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

Last updated on FEBRUARY 01, 2022

Applies to:

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


This document describes the new OWB 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.


OWB and higher


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

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