The Oracle GoldenGate commands with the specified options are listed in the following sections.
For an explanation of the ADD EXTRACT command, see the Reference for Oracle GoldenGate for Windows and UNIX.
| ADD EXTRACT Command | Oracle GoldenGate Studio Label |
|---|---|
ADD EXTRACT |
Add Extract |
SOURCEISTABLE |
Table |
TRANLOG |
Transaction Log |
INTEGRATED TRANLOG |
Integrated Capture Mode |
VAM |
Vendor Access Module |
EXTFILESOURCE |
Source File Name |
EXTTRAILSOURCE |
Source Trail Name |
VAMTRAILSOURCE |
VAM Trail Name |
BEGINNOW |
Now |
EXTSEQNO |
At Sequence Number |
EXTRBA |
Relative Byte Address |
EOF |
End of Log File |
LSN |
LSN |
EXTRBA |
Relative Byte Address |
PAGE |
Page |
ROw |
ROW |
SEQNO |
Sequence Number |
SCN |
System Change Number |
THREADS |
Threads |
PASSIVE |
Passive |
PARAMS |
Parameter File |
REPORT |
Report File |
DESC |
Description |
For an explanation of the ADD REPLICAT command, see the Reference for Oracle GoldenGate for Windows and UNIX.
| ADD REPLICAT Options | Oracle GoldenGate Studio Label |
|---|---|
ADD REPLICAT |
Add Replicat |
INTEGRATED |
Integrated |
COORDINATED |
Coordinated |
MAXTHREADS |
Max Threads |
SPECIALRUN |
Special Run |
EXTFILE |
Extract File |
EXTTRAIL |
Extract Trail |
BEGIN |
Begin |
NOW |
Now |
EXTSEQNO |
Sequence Number |
EXTRBA |
Relative Byte Address |
CHECKPOINTTABLE |
Checkpoint Table |
NODBCHECKPOINT |
No Checkpoint Table |
PARAMS |
Parameter File |
REPORT |
Report File |
DESC |
Description |
For an explanation of the ADD EXTRAIL command, see the Reference for Oracle GoldenGate for Windows and UNIX.
| ADD EXTTRAIL Options | Oracle GoldenGate Studio Label |
|---|---|
ADD EXT TRAIL |
Add Extract Trail |
EXTRACT |
Extract |
MEGABYTES |
Megabytes |
SEQNO |
Sequence Number |
For an explanation of the ADD RMTTRAIL command, see the Reference for Oracle GoldenGate for Windows and UNIX.
| ADD RMTTRAIL Options | Oracle GoldenGate Studio Label |
|---|---|
ADD RMTTRAIL |
Add Remote Trail |
EXTRACT |
Extract |
MEGABYTES |
Megabytes |
SEQNO |
Sequence Number |
For an explanation of the REGISTER EXTRACT command, see the Reference for Oracle GoldenGate for Windows and UNIX.
| REGISTER EXTRACT Options | Oracle GoldenGate Studio Label |
|---|---|
REGISTER EXTRACT |
Register Extract |
DATABASE |
Database |
CONTAINER |
Container |
ADD CONTAINER |
Add Container |
DROP CONTAINER |
Drop Container |
LOGRETENTION |
Log Retention |
SCN |
System Change Number |
For an explanation of the START EXTRACT command, see the Reference for Oracle GoldenGate for Windows and UNIX.
| Start Extract Command | Oracle GoldenGate Studio Label |
|---|---|
START EXTRACT |
Start Extract |
ATCSN |
At CSN |
AFTERCSN |
After CSN |
For an explanation of the START REPLICAT command, see the Reference for Oracle GoldenGate for Windows and UNIX.
| Start Replicat Command | Oracle GoldenGate Studio Label |
|---|---|
START REPLICAT |
Start Replicat |
SKIPTRANSACTION |
Skip Transaction |
ATCSN |
At CSN |
AFTERCSN |
After CSN |
FILTERDUPTRANSACTIONS |
Filter duplicate Transactions |
THREADS |
Threads |
For an explanation of the Trandata commands, see the Reference for Oracle GoldenGate for Windows and UNIX.
| Add Supplemental Logging Command | Oracle GoldenGate Studio Label |
|---|---|
ADD SCHEMATRANDATA |
Enable Schema Supplemental Logging |
ALLCOLS |
Logging Columns |
ALLOWNONVALIDATEDKEYS |
Allow Non-Validated Keys |
ADD TRANDATA |
Enable Table Supplemental Logging |
COLS |
Logging Columns |
NOKEY |
Suppress primary key columns |
INCLUDELONG |
Include LONGVAR columns |
EXCLUDELONG |
Exclude LONGVAR columns |