Are any other Compose users experiencing significant table fragmentation in their data mart (TDMA) tables? For example, one of our data warehouse tables is 31.7 gb and its data mart equivalent table is 129gb. The data and rowcounts in each table is the same. If we move the table to another tablespace and then move it back, the size of the table goes back to normal and the wasted space is gone. This workaround is far from ideal. Does anyone have any suggestions?
We are on Oracle 12.1.
