tablespace for the PK_DATABASECHANGELOG and PK_DATABASECHANGELOGLOCK indexes

General Discussion
1

Is there a way to define the tablespace for the PK_DATABASECHANGELOG and the PK_DATABASECHANGELOGLOCK indexes?
I would like to put them on a different tablespace from the user’s default.
And for that matter, how about defining the tablespace for the DATABASECHANGELOG and DATABASECHANGELOGLOCK tables?
Ion

2

I expect you’d have to dump the table definitions to an SQL file, modify it to name the tablespace, and construct the new tables manually.

3

That is right.  If you are using Liquibase 2.0, there is the option of creating an extension that will override the default CreateDatabaseChangeLogGenerator class and allow you to hook in whatever changes to the SQL you want transparently.

Nathan