Oracle comparison settings
Published 21 July 2023
These are the settings relating to database comparisons and deployment script generation for Oracle. You can also update these through the Flyway Desktop UI.
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 = ""
