Is it possible to manage an oracle database with flyway?
If You would create the DB with some limited super-user account, You could use it to create users and tablespaces, having a separate Flyway migration instance. That is:
- Flyway migration by super-user from
sql/db-configuration/
using dedicatedflyway.conf
- creates users, tablespaces, and all other configuration
- Flyway migration by application-user from
sql/app-code/
using dedicatedflyway.conf
- regular application code