Back to Flyway

Oracle Ignore Options Namespace

documentation/Reference/Configuration/Redgate Compare Namespace/Redgate Compare Oracle Namespace/Oracle Ignore Options Namespace.md

latest8.6 KB
Original Source

This namespace contains the configurations relating to the database features/syntax to track when running Oracle database comparisons.

Settings

SettingTypeDescription
ignoreSlowDependenciesBooleanIgnore certain dependencies that affect comparison performance when comparing databases.
ignoreDependentObjectsInOtherSchemasBooleanIgnore calculating dependent objects in schemas that haven't been explicitly selected for comparison.
ignoreWhitespaceBooleanIgnore whitespace (e.g. newlines, tabs, spaces) in PL/SQL blocks when comparing databases.
ignoreCaseDifferencesInPlSqlBlocksBooleanIgnore case differences in object SQL creation scripts when comparing databases.
ignoreDoubleQuotesInPlSqlBlocksBooleanIgnore double quotation marks around identifiers in PL/SQL blocks when comparing databases.
ignoreExternalTableLocationInformationBooleanIgnore the external table location information when comparing tables.
ignoreCommentsInPlSqlBlocksBooleanIgnore comments in PL/SQL blocks when comparing databases.
ignoreCommentsOnTablesViewsAndColumnsBooleanIgnore comments on tables, views, and columns when comparing databases.
ignoreConstraintNamesBooleanIgnore the names of foreign keys and primary keys, and default, unique, and check constraints when comparing databases.
ignoreIndexNamesBooleanIgnore index names for comparison.
ignoreParallelBooleanIgnore differences in the parallel clause on indexes and tables.
ignoreSequenceCurrentValueBooleanIgnore the current value of sequences when comparing and deploying databases.
ignorePermissionsBooleanIgnore differences in object permissions.
ignoreSupplementalLogGroupsBooleanIgnore supplemental log groups when comparing tables.
ignoreMaterializedViewStartWithValueBooleanIgnore materialized view START WITH value.
ignoreLengthSemanticsBooleanIgnore length semantics differences for columns.
ignoreSystemPartitionsBooleanIgnore system partitions.
ignoreLobStorageBooleanIgnore lob storage details when comparing and deploying schemas.
ignoreSequenceIncrementByBooleanIgnore the INCREMENT BY property of sequences only when comparing databases.
ignoreSequenceMinValueBooleanIgnores the MINVALUE property of sequences only when comparing databases.
ignoreSequenceMaxValueBooleanIgnores the MAXVALUE property of sequences only when comparing databases.
ignoreInvisibleColumnsBooleanIgnores invisible columns when comparing databases.
ignoreInvisibleIndexesBooleanIgnores invisible indexes when comparing databases.