My SAP consultant said, after having SAP Data Archiving, we have to have Table Reorg so that Oracle would release the free hard disk space to us.
But my question is :
I found our Oracle still released the free tablespace to us even we hadn't done any Table Reorg after Data Archiving.
So, if we have had Data Archive, is it necessary to have Table Reorg otherwise Oracle will NEVER release its free tablespace to us ?
Or, Table Reorg is just "Nice to have", that means : if no Table Reorg, Oracle will still release its free tablespace to us ?
Which one is correct ?
Can you tell me ?
Thanks a lot.