Pausing the Shrink Command
793661Sep 8 2010 — edited Sep 8 2010Hello ALL,
We have recently purged some of the data on a huge table and right now the unused space is upto 350 GB. We need to reclaim the space.It's a 10 G database. But, since it's a resource intensive operation we have a requirement from the business that it should be stopped at the start of business day and commence it at the EOB.
Do you think we should kill the Shrinking operation at the EOB. does Oracle satrt the Shrinking operation where it stopped from.
P.S. this table has all LOB columns, LONG type columns. so, there is no possibility of expdp/MOVE.
Please throw your valuable inputs.
Thanks,