Oracle comparison settings
Published 21 July 2023
These are the settings relating to database comparisons and deployment script generation for Oracle.
Oracle settings table
Name | Required? | Type | Description |
|---|---|---|---|
ignoreRulesFile | Yes | String | The path to your Oracle Compare ignore rules file |
filterFile | Yes | String | The path to your Oracle Compare filter file |
edition | No | String | The Oracle Edition |
schemaSettings | No | Schema settings table | Comparison settings relating to schemas |
dataSettings | No | Data settings table | Comparison settings relating to data |
Oracle schema settings table
Name | Required? | Type | Description |
|---|---|---|---|
behaviourSettings | No | Behaviour settings table | Comparison behaviour settings |
ignoreSettings | No | Ignore settings table | Comparison ignore settings |
storageSettings | No | Storage settings table | Comparison storage settings |
Oracle schema behaviour settings table
Name | Required? | Type |
|---|---|---|
forceColumnOrder | No | Boolean |
useForwardSlash | No | Boolean |
includeSetDefineOff | No | Boolean |
includeSetBlankLinesOn | No | Boolean |
includeSystemPermissions | No | Boolean |
includeUserRoles | No | Boolean |
includeProgramUnitRoles | No | Boolean |
includeCrossSchemaPermissions | No | Boolean |
excludeSchemaNames | No | Boolean |
detectRenamedColumns | No | Boolean |
addPurgeClauseToAllTableDrops | No | Boolean |
suppressDependentAlterCompile | No | Boolean |
includeSetDefineOffToScripter | No | Boolean |
Oracle schema ignore settings table
Name | Required? | Type |
|---|---|---|
ignoreSlowDependencies | No | Boolean |
ignoreDependentObjectsInOtherSchemas | No | Boolean |
ignoreWhitespace | No | Boolean |
ignoreCaseDifferencesInPlSqlBlocks | No | Boolean |
ignoreDoubleQuotesInPlSqlBlocks | No | Boolean |
ignoreExternalTableLocationInformation | No | Boolean |
ignoreCommentsInPlSqlBlocks | No | Boolean |
ignoreCommentsOnTablesViewsAndColumns | No | Boolean |
ignoreConstraintNames | No | Boolean |
ignoreIndexNames | No | Boolean |
ignoreParallel | No | Boolean |
ignoreSequenceCurrentValue | No | Boolean |
ignorePermissions | No | Boolean |
ignoreSupplementalLogGroups | No | Boolean |
ignoreMaterializedViewStartWithValue | No | Boolean |
ignoreLengthSemantics | No | Boolean |
ignoreSystemPartitions | No | Boolean |
ignoreLobStorage | No | Boolean |
Oracle schema storage settings table
Name | Required? | Type |
|---|---|---|
includeAllStorage | No | Boolean |
includeStorageCompression | No | Boolean |
includeStorageDeferredSegments | No | Boolean |
includeStorageExtents | No | Boolean |
includeStorageIlmPolicies | No | Boolean |
includeStorageIniTrans | No | Boolean |
includeStorageLobsAndVarrays | No | Boolean |
includeStorageLogging | No | Boolean |
includeStoragePartitioning | No | Boolean |
includeStoragePctFree | No | Boolean |
includeStorageTablespace | No | Boolean |
Oracle data settings table
Name | Required? | Type | Description |
|---|---|---|---|
comparisonSettings | No | Data comparison settings table | Data comparison settings |
Oracle data comparison settings table
Name | Required? | Type |
|---|---|---|
| checkTablesForData | No | Boolean |
includeViews | No | Boolean |
trimTrailingSpaces | No | Boolean |
ignoreControlCharacters | No | Boolean |
ignoreWhiteSpace | No | Boolean |
includeSourceTables | No | Boolean |
ignoreDateTypeDifferences | No | Boolean |
databaseTimeZone | No | String |
Example
[redgateCompare.oracle] ignoreRulesFile = "IgnoreRules.scpf" filterFile = "Filter.scpf" [redgateCompare.oracle.options.behavior] forceColumnOrder = false useForwardSlash = false includeSetDefineOff = true includeSetBlankLinesOn = false includeSystemPermissions = false includeUserRoles = false includeProgramUnitRoles = false includeCrossSchemaPermissions = true excludeSchemaNames = false detectRenamedColumns = true addPurgeClauseToAllTableDrops = false suppressDependentAlterCompile = false includeSetDefineOffToScripter = true [redgateCompare.oracle.options.ignores] ignoreSlowDependencies = true ignoreDependentObjectsInOtherSchemas = true ignoreWhitespace = true ignoreCaseDifferencesInPlSqlBlocks = false ignoreDoubleQuotesInPlSqlBlocks = true ignoreExternalTableLocationInformation = false ignoreCommentsInPlSqlBlocks = false ignoreCommentsOnTablesViewsAndColumns = false ignoreConstraintNames = false ignoreIndexNames = false ignoreParallel = false ignoreSequenceCurrentValue = true ignorePermissions = true ignoreSupplementalLogGroups = false ignoreMaterializedViewStartWithValue = true ignoreLengthSemantics = false ignoreSystemPartitions = false ignoreLobStorage = false [redgateCompare.oracle.options.storage] includeAllStorage = false includeStorageCompression = false includeStorageDeferredSegments = false includeStorageExtents = false includeStorageIlmPolicies = false includeStorageIniTrans = false includeStorageLobsAndVarrays = false includeStorageLogging = false includeStoragePartitioning = false includeStoragePctFree = false includeStorageTablespace = false [redgateCompare.oracle.data.options.comparison] checkTablesForData = false includeViews = false trimTrailingSpaces = false ignoreControlCharacters = false ignoreWhiteSpace = false includeSourceTables = false ignoreDateTypeDifferences = false databaseTimeZone = ""
