Oracle Behavior Options Namespace
Published 15 January 2025
This namespace contains the configurations relating to Oracle database comparison and script generation behavior.
Settings
Setting | Type | Description |
---|---|---|
forceColumnOrder |
Boolean | If additional columns are inserted into the middle of a table, this option forces a rebuild of the table so the column order is correct following deployment. |
useForwardSlash |
Boolean | Terminate each statement in the deployment script with a forward slash. |
includeSetDefineOff |
Boolean | Add SQL*Plus command SET DEFINE OFF to the top of the script file, so substitution variables aren't used when running the script. |
includeSetBlankLinesOn |
Boolean | Add the SQL*Plus command SET SQLBLANKLINES ON to the top of the script, so blank lines and new lines are interpreted as part of a SQL command or script. |
includeSystemPermissions |
Boolean | Add system permissions to the top of the script. |
includeUserRoles |
Boolean | Include user roles. |
includeProgramUnitRoles |
Boolean | Include program unit roles. |
includeCrossSchemaPermissions |
Boolean | Include permissions to/from other schemas that referencing to compared schemas or are referenced by compared schemas. |
excludeSchemaNames |
Boolean | Exclude schema names from the deployment script. |
detectRenamedColumns |
Boolean | Attempt to identify renamed columns by matching the strings, position in the table, and datatype. |
addPurgeClauseToAllTableDrops |
Boolean | Immediately release the space associated with dropped tables, instead of moving tables and their dependents to the recycle bin. |
suppressDependentAlterCompile |
Boolean | (Experimental) Turns off all calculations and scripting associated with performing an ALTER COMPILE on objects that are dependent on those that are deployed. |
includeSetDefineOffToScripter |
Boolean | Adds SQL*Plus command SET DEFINE OFF to the top of repeatable migration script files, so substitution variables aren't used when running the script. |