Valid For

Extract

Description

Use the SOURCEISTABLE parameter to extract complete records directly from source tables in preparation for loading them into another table or file. SOURCEISTABLE extracts all column data specified within a TABLE statement.

This parameter applies to the following initial load methods:

• Loading data from file to Replicat.

• Loading data from file to database utility.

Do not use this parameter for the following initial load methods:

• An Oracle GoldenGate direct load, where Extract sends load data directly to the Replicat process without use of a file.

• An Oracle GoldenGate direct bulk load to SQL*Loader.

For those processes, SOURCEISTABLE is specified as an ADD EXTRACT argument instead of being used in the parameter file.

When used, SOURCEISTABLE must be the first parameter statement in the Extract parameter file.

To use SOURCEISTABLE, disable DDL extraction and replication by omitting the DDL parameter from the Extract and Replicat parameter files. See "DDL" for more information.

See Administering Oracle GoldenGate for more information about configuring initial data loads.

Default

None

Syntax

SOURCEISTABLE