Hi,
   As part of our pipeline, we want to test the deployment scripts on a test database before merging the PR. So when I try to run flyway migrate which already has the baseline script. Since the schema doesnt exist,expecting flyway to create the schema. However it fails with ORA-01950: no privileges on tablespace when it tries to 
INSERT INTO "SCHEMA"."flyway_schema_history".

How can I get around the issue?
Since I cannot grant quota before the schema existence.
sanredch
0

Comments

1 comment

  • Peter_Laws
    Hello sanredch,

    If a dryrun approach doesn't suit your needs here and you want to stick to the implementation you have, I'd recommend a callback to execute the tablespace definition and assignment before the migration runs.
    Peter_Laws
    0

Add comment

Please sign in to leave a comment.