Incorrect Tablespace used on schema compare
Posted: Fri 05 Jun 2020 08:07
Hi,
I've just done a schema compare between two databases and as part of that dbForge identified a table needed to be rebuilt as it couldn't be altered without data loss.
When reapplying the indexes it makes the correct choice regarding the tablespace to use, but when applying the constraints back it tries to use a tablespace from the source database and not the target.
Any ideas on how to overcome? I've emailed support but not sure how fast they'll respond. I've selected it ignore tablespace and storage clauses.
I've just done a schema compare between two databases and as part of that dbForge identified a table needed to be rebuilt as it couldn't be altered without data loss.
When reapplying the indexes it makes the correct choice regarding the tablespace to use, but when applying the constraints back it tries to use a tablespace from the source database and not the target.
Any ideas on how to overcome? I've emailed support but not sure how fast they'll respond. I've selected it ignore tablespace and storage clauses.