Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Custom tablespace for schema history table #865

Closed
axelfontaine opened this issue Oct 16, 2014 · 3 comments
Closed

Custom tablespace for schema history table #865

axelfontaine opened this issue Oct 16, 2014 · 3 comments

Comments

@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Oct 16, 2014

  • Optional support for databases that have this feature.
  • Use default tablespace unless set
  • Ignored for databases that don't support this
@crgardner
Copy link

@crgardner crgardner commented Mar 15, 2016

Is there now first class support in Flyway to specify the tablespace in Oracle? If so, how do you configure it?

@mahidbdw
Copy link

@mahidbdw mahidbdw commented Jun 25, 2018

I believe DB2 z/OS is no more supported.
But this is still valid in DB2 LUW.
Can we add tablespace place holders for your flyway metadata table, which should pickup the values specified, if no value specified it should go to default tablespace ( which is happening presently)

@axelfontaine axelfontaine changed the title tablespace setting for metadata table Custom tablespace for schema history table Jan 23, 2019
axelfontaine pushed a commit to flyway/flywaydb.org that referenced this issue Jan 23, 2019
@sbelan
Copy link

@sbelan sbelan commented Aug 19, 2019

@axelfontaine, I tried custom table space with latest beta version and its still failing at the time of alter table. Please find below details.
Flyway gradle version: 6.0.0

Before using beta version I was getting below exception
ERROR: permission denied for tablespac xyz

Now I am using beta version and provided parameter flyway.tablespace=xyz and getting below exception

`
Migration failed

SQL State : 42501
Error Code : 0
Message : ERROR: permission denied for tablespace xyz
Location : ()
Line : 14
Statement : ALTER TABLE "postgres"."flyway_schema_history" ADD CONSTRAINT "flyway_schema_history_pk" PRIMARY KEY ("installed_rank")`

Could you please help?

dohrayme pushed a commit to dohrayme/flyway that referenced this issue Feb 3, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
4 participants