11.2.0.4
Have a process that solely inserts append to a partitioned table. partitioned on an id. Table is only updated either through these inserts or a partition drop on the ID.
Im moving the table to re-organize the partitions and noticed that an 80gb table went down to below 40gb. this tell me something is wasting space, most likely the append as it inserts into blocks above the HWM then the unused space in the highest block wont used. (my understanding of it which is open to correction)
Ok, we can reclaim the space with some table moves but is there a way we can organise the tables structures so the append doesnt waste as much space going forward? I have other much larger tables that Im getting to shortly that will be affected.
thanks.