SOURCEISTABLE
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
Parent topic: Oracle GoldenGate Parameters