| Oracle GoldenGate Parameters/Options | Oracle GoldenGate Studio Label |
|---|---|
batchsql.nobatcherrormode |
No Batch Error Mode |
batchsql.nobypasspkcheck |
Don't Bypass PK Check |
batchsql.nocheckuniquekeys |
Don't Check Unique Keys |
batchsql.noerrorhandling |
No Error Handling |
bulkload.nologging |
Disable Redo Logging |
bulkload.noparallel |
Disable Parallel Loading |
dboptions.noallowlobdatatruncate |
Disallow LOB Truncation |
dboptions.noallowunusedcolumn |
Disallow Unused Columns |
dboptions.nocatalogconnect |
No Separate Catalog Connection |
dboptions.nofetchlobs |
Disallow LOB Fetching |
dboptions.nolimitrows |
Don't Limit Rows |
dboptions.noreparselobsql |
Don't Reparse LOB SQL |
dboptions.noshowwarnings |
Don't Log Warnings |
dboptions.noskiptemplob |
Don't Skip Temp LOB |
dboptions.nospthread |
No Separate Connection For Stored Procedures |
dboptions.nosuppresstriggers |
Don't Suppress Triggers |
ddloptions.CROSSRENAME |
Cross Rename |
ddloptions.ignoreapplops |
Ignore Application Operations |
ddloptions.ignorereplicates |
Ignore Replicat Transactions |
ddloptions.nomapderived |
Disallow Derived Name Mapping |
ddloptions.noreplicatepassword |
Don't Replicate Password |
ddloptions.noreport |
Don't Log DDL Operations To Report File |
disableheartbeat |
Disable Heartbeat |
disableheartbeattable |
Disable Heartbeat Table |
disablenewmanager |
Disable New Manager |
extfile.no_objectdefs |
No Object Definitions |
exttrail.no_objectdefs |
No Object Definitions |
fetchoptions.nodetaileddiagnostics |
No Detailed Diagnostics |
fetchoptions.nodiagnosticsonall |
No Diagnostics On All |
fetchoptions.nousediagnostics |
Don't Use Diagnostics |
fetchoptions.nousekey |
Don't Use Key |
fetchoptions.nouselatestversion |
Don't Use Latest Version |
fetchoptions.nouserowid |
Don't Use Row ID |
fetchoptions.nousesnapshot |
Don't Use Snapshot |
fetchoptions.suppressduplicates |
Suppress Duplicates |
formatascii._noind |
No Ind |
formatascii._noop |
No Op |
formatascii._nots |
No TS |
formatascii.nonames |
Exclude Column Names |
formatxml.noinlineproperties |
Write Properties Outside XML Tab |
formatxml.notrans |
Exclude Commit Markers |
ignorealters |
Ignore Alters |
ignoreapplops |
Ignore Application Operations |
ignorecreates |
Ignore Creates |
ignoredeletes |
Ignore Deletes |
ignoredrops |
Ignore Drops |
ignoreinserts |
Ignore Inserts |
ignorereplicates |
Ignore Replicat Transactions |
ignoretruncates |
Ignore Truncates |
ignoreupdateafters |
Ignore Update After Images |
ignoreupdatebefores |
Ignore Update Before Images |
ignoreupdates |
Ignore Updates |
map.nohandlecollisions |
Don't Handle Collisions |
map.noinsertappend |
Don't Insert Append |
map.noinsertmissingupdates |
Don't Insert Missing Updates |
map.nomapinvisiblecolumns |
Don't Map Invisible Columns |
map.notrimspaces |
Don't Trim CHAR to VARCHAR Trailing Spaces |
map.notrimvarspaces |
Don't Trim VARCHAR to CHAR Trailing Spaces |
no_use_traildefs |
Don't Use Trail Definitions |
noallowduptargetmap |
Don't Allow Duplicate Target Map |
noallowlargefloat |
Don't Allow Large Float |
noallownoopupdates |
Don't Allow No-Operation Updates |
noapplynoopupdates |
Don't Apply No-Operation Updates |
noassumetargetdefs |
Don't Assume Target Definitions |
noauditreps |
Don't Audit Replicats |
nobinarychars |
Don't Use Binary Characters |
nocachenullablecols |
Don't Cache Nullable Columns |
nocharsetconversion |
Disable Character Set Conversion |
nochecksequencevalue |
Don't Check Sequence Values |
nocomplexnullcond |
No Complex Null Conditions |
nocompressdeletes |
No Compress Deletes |
nocompressupdates |
No Compress Updates |
nodeletelogrecs |
Don't Delete Log Records |
nodynamicresolution |
No Dynamic Resolution |
nodynsql |
No Dynamic SQL |
nofilterdups |
Don't Filter Duplicates |
nohandlecollisions |
Don't Handle Collisions |
noinsertappend |
No Insert Append |
noinsertdeletes |
Don't Insert Deletes |
noinsertmissingupdates |
Don't Convert Failed Updates To Inserts |
noinsertupdates |
Don't Insert Updates |
nolist |
Don't List Parameters in Report File |
nologallsupcols |
Don't Capture All Supplementally Logged Columns |
nomapinvisiblecolumns |
Don't Map Invisible Columns |
nooverridedups |
Don't Override Duplicates |
nopassthru |
Disable PassThru |
nopassthrumessages |
Disable PassThru Messages |
norestartcollisions |
Don't Restart Collisions |
nospacestonull |
Don't Convert Spaces to Null |
notcpsourcetimer |
Do Not Compensate For System Clock Differences |
notrimspaces |
Don't Trim CHAR to VARCHAR Spaces |
notrimvarspaces |
Don't Trim VARCHAR to CHAR Spaces |
noupdatedeletes |
Don't Convert Deletes To Updates |
noupdateinserts |
Don't Convert Inserts To Deletes |
nouseansisqlquotes |
Don't Use ANSI SQL Quotes |
nousededicatedcoordinationthread |
Don't Use Dedicated Coordination Thread |
novarwidthnchar |
Don't Treat NCHAR, NVARCHAR2, NCLOB As UTF-16 |
purgeoldextracts.no_use_checkpoints |
Don't Use Checkpoints |
reportcount.norate |
Don't Report Rate |
rmtfile.no_objectdefs |
No Object Definitions |
rmttrail.no_objectdefs |
No Object Definitions |
showsyntax.apply |
Apply |
statoptions.noreportdetail |
No Operation Statistics |
statoptions.noreportfetch |
Don't Fetch Statistics |
statoptions.noresetreportstats |
Don't Reset Report Statistics |
table.notrimspaces |
Don't Trim CHAR to VARCHAR Spaces |
table.notrimvarspaces |
Don't Trim VARCHAR to CHAR Spaces |
trail_seqlen_6d |
Trail Sequence Length 6 digits |
tranlogoptions._noarchivedlogonly |
Don't Read Only From Archived Logs |
tranlogoptions.ignoremetadatafromvam |
Ignore Metadata From VAM |
tranlogoptions.noapifilter |
No API Filter |
tranlogoptions.nocompletearchivedlogonly |
No Complete Archived Log |
tranlogoptions.nogetctasdml |
Don't Get CTAS DML |
tranlogoptions.nomanagesecondarytruncationpoint |
Manage Secondary Truncation Point |
tranlogoptions.nominefromactivedg |
Don't Mine From Active Data Guard |
tranlogoptions.nominefromsnapshotstby |
Don't Mine From Standby Snapshots |
tranlogoptions.noprepareforupgradetoie |
Don't Prepare For Upgrade To Integrated Extract |
tranlogoptions.nopurgeorphanedtransactions |
Don't Purge Orphaned Transactions |
tranlogoptions.nousenativeobjsupport |
Don't Use Native Object Support |
tranlogoptions.nouseprevresetlogsid |
Don't Use Previous Reset Log SID |
tranlogoptions.nouserexit |
No Userexit |