Description

Immediately releases the space associated with dropped tables, instead of moving tables and their dependents to the recycle bin.

Note: if this option is selected, you won’t be able to recover dropped tables.

Type

Boolean

Default

false

Usage

Flyway Desktop

This can be set from the comparison options settings in Oracle projects.

Command-line

./flyway diff -redgateCompare.oracle.options.behavior.addPurgeClauseToAllTableDrops=true

TOML Configuration File

[redgateCompare.oracle.options.behavior]
addPurgeClauseToAllTableDrops = true