Flyway Teams

Description

Enable Flyway's support for Oracle SQL*Plus commands.

Type

Boolean

Default

false

Usage

Flyway Desktop

This can't be set in a config file via Flyway Desktop, although it will be honoured, and it can be configured as an advanced parameter in operations on the Migrations page.

Command-line

./flyway -oracle.sqlplus="true" info

TOML Configuration File

[flyway.oracle]
sqlplus = true

Configuration File

flyway.oracle.sqlplus=true

Environment Variable

FLYWAY_ORACLE_SQLPLUS=true

API

OracleConfigurationExtension oracleConfigurationExtension = configuration.getPluginRegister().getPlugin(OracleConfigurationExtension.class);
oracleConfigurationExtension.setSqlPlus(true);

Gradle

flyway {
    oracleSqlplus = true
}

Maven

<configuration>
    <oracleSqlplus>true</oracleSqlplus>
</configuration>

Use Cases

Configuring consistent sessions for your migrations

See our list of supported SQL*Plus commands and how you can utilize them with site and user profiles once SQL*Plus is enable to achieved this.