Flyway Migrations with Oracle 12c

I’m looking to get Flyway migrations setup with Oracle 12C, however running the ‘flyway baseline’ i receive the following error on schema_table creation.

Message : ORA-01950: no privileges on tablespace ‘USERS’

The end-goal here with this setup is to get a CI and CD process that can create an Oracle Database (with DBCA) then run flyway migrate to migrate the database to the latest version.

With that in mind, how can i get passed this issue? Do i need to create the scheme and tablespace configuration outside of Flyway before i do anything?

Source: oracle

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.