Oracle Behavior Options Namespace - Flyway

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.
`includeDependencies`	Boolean	Includes dependent objects when comparing and deploying databases.
`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.