1.72 FILEGROUP
Valid For
For SQL Server only.
Description
Overrides the default database filegroup (PRIMARY) when adding TRANDATA to tables and creating the SQL Server CDC capture tables on the designated filegroup.
The filegroup must exist in the database and have a valid database file attached to
it. The GLOBALS FILEGROUP
parameter can be overwritten by the
following statement, if required, but this is not normally necessary:
ADD TRANDATA schemaname.tablename FILEGROUP filegroupname
If the FILEGROUP
parameter exists in GLOBALS, then the ADD
HEARTBEATTABLE
command also creates the SQL Server CDC capture tables
for the heartbeat tables on the designated filegroup.
See Enabling Supplemental Logging (CDC Extract) in Using Oracle GoldenGate for Heterogeneous Databases.
Parent topic: Oracle GoldenGate Parameters