The Oracle GoldenGate commands with the specified options are listed in the following sections.
For an explanation of the ADD EXTRACT
command, see the .
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 .
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 .
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 .
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 .
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 .
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 .
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 .
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 |