Hi All,
Need your advise on LOB segment shrink. I have a table with clob column that contains xml data. size of the log segment is around 120GB. Due to space constraint we are planning to reclaim some space from the LOB segment by updating 25% of clob column data to null. Once we update this clob to null we would like to reclaim this space.
So can you please tell is it advisable to apply the shrink command on this LOB segment which is around 120GB? If yes any idea how long it would take to complete the execution of shrink command assuming I have good memory configuration?
Any other ideas also welcome here to reclaim the space from LOB segment. I am having Oracle 11gR2 database.
Thanks&Regards,
Shiva.