tablespace quota
sanredch
Posts: 1 New member
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.
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.
Tagged:
Answers
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.