CODEWITHSUNDEEP
oracle-databasemigrationflywayoracle12c
Stunt
Stunt

Reputation: 1434

Flyway Migrations with Oracle 12c

I'm looking to get Flyway migrations setup with Oracle 12C, however running the 'flyway baseline' I received 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?.

Edit: Moudiz has suggested ALTER USER quota 100M on USERS, whilst that does get me passed the issue. I'd be more interested in a solution in the area of dbca/flyway configuration. Any extra 'tweak' script i need to run for deployment is not ideal.

Upvotes: 0

Views: 1644

Answers (1)

Moudiz
Moudiz

Reputation: 7387

this statement should help you.

 ALTER USER <user> quota 100M on USERS

Upvotes: 1

Related Questions