flyway


how to override flywaydb V4.2.0 oracle system schema clean changes


Among the changes in flywaydb V4.2.0 is enforcement of disabling of the clean function for oracle system schemas. This is a sensible move, but is causing issues for us because we have numerous schemas that have been created, perhaps naively, in the root container in oracle 12c. This means that we have many schemas that are considered by flyway to be oracle system schemas, though they are in fact user created, which it refuses to clean.
The most technically correct solution would be to create these schemas in a PDB rather than the root container, but due to the work required to migrate to a PDB with the large number of schemas that we have it may well not be an option that the business is willing to consider, certainly not in a big-bang way that affects all schemas at once.
Ideally we would like to be able to override or modify the behaviour of flyway when working with these schemas to allow clean during development and testing. Is there an existing solution that would permit this, either by setting a flyway execution option or by changing metadata in the target database? This will allow us to migrate at an appropriate pace to properly configured PDB containers and still upgrade to V4.2.0 or later flyway versions. Without a solution to this we are stuck with flyway V4.1.2 until we have migrated all schemas that we work with.

Related Links

Retry a flyway failed migration
Can I use numbers in descriptions to force a loading order for SQL files?
Flyway 1.7 migrations transaction
how does flyway lock a postgres schema?
Flyway migrate Oracle PL/SQL dump
Why version counter and not timestamps
executing more than one statement at once
How to get flyway to re-run migration?
How to build Flyway without all JDBC Drivers
How do placeholders work in Flyway?
Flyway SQL directory not found while migrating from within a war
Can Flyway find out and generate migration files from datamodel?
Flyway: Unable to find path for sql migrations
Flyway: how to find out maximum version available to migrate()?
Using flyway to efficiently manage repeatable scripts
getting started with flyway for one with no java experience

Categories

HOME
google-apps-script
signalr
oauth
itext
translation
puppet
json-ld
d
cocos2d-x-3.0
docker-swarm
ubuntu-12.04
apache2
azureservicebus
vsftpd
goutte
structuremap
maxima
react-leaflet
postmessage
aspell
mousewheel
clover
koa
prediction
memsql
nmf
csh
croppic
geopandas
ui5
maximo
vertex-buffer
gpib
read-write
exponential
spreedly
body-parser
von-neumann
swagger-editor
android-preferences
sendgrid-templates
mediawiki-extensions
homekit
matlab-cvst
dojox.grid.datagrid
appstore-approval
persistent
rpostgresql
fedora20
gce
fontconfig
pspice
libreadline
cleditor
spring-ioc
debugdiag
tomcat5
project-online
picking
eml
achartengine
castle-windsor-3
ibm-data-studio
word-2013
pl-i
rhel5
cloudpebble
ultrawingrid
odftoolkit
sortable
dto
facebook-wall
getimagedata
colt
voldemort
indexing-service
visualstatemanager
flash-cc
chrome-for-android
real-time-updates
convex-polygon
installshield-2011
vertical-rhythm
javascriptmvc
digital-design
xml-libxml
gdataxml
android-4.0
ninject-extensions
hashalgorithm
port-scanning
libavformat
out-of-browser
task-management
kpi
castle-validators
data-entry
weborb
self-reference

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App