We have the same oracle schema’s deployed in environments where the tablespaces holding tables and indexes is not necessarily the same, and when running liquibase diff, we end up with a difference for every index . e.g.
Changed Index(s):
WO_SPA_I ON WFX.WORK_ORDER(SPA)
tablespace changed from 'INDX' to 'BIG_INDX'
In addition, the diff-changelog output wants to drop and recreate every index, UK and PK.
Is there a way to ignore tablespaces when performing a diff?