For PostgreSQL users - where are your DBs hosted?

Oracle Behavior Options Namespace

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.

Didn't find what you were looking for?