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?