How to get table space released after OSM Order Purging
edited Nov 19, 2014 1:47AM in Order and Service Management (Communications Industry) (MOSC) 2 commentsAnswered
Hi,
We are using OSM 7.2.2.2.2 build 425.
As part of our DB maintenance, we are using orderpurge utility to delete old orders. However, even after the orderpurging script execution is completed succesfully the tablespace size is not getting released/shrinked.
We are running shrink space command manually by enabling row movement and disabling after shrinking is done.
For Example:
OSM_Large_Index - 78 %(used)
It wil be the same even after orderpurge is completed, but once we follow the above approach the space is getting released.
OSM_Large_Index - 58 %(used)
Is there a way that orderpurge command itself does the shrink job.
0