We are facing Huge size occupation by BLOB segment - Single segment Size 6TB
Hi
We are trying to archive some data from one table which is having BLOB column .
Its LOB segment size is 6TB.
We tried to export FY20 data from the table & deleted the same data from the table.Its around 430GB. Taken 5Hrs to export with parallelism 16 & deletion of same data taken 30Mins.
After deletion also space not released from the table , same before & after deletion of data from the table.
So trying to shrink table size using
ALTER TABLE prod_ifmis.Tablename MODIFY LOB(lob column) (SHRINK SPACE CASCADE);
But its running since 2 days .
Also one clarification , Is the space ( rows deleted from table space ) used by the table for the new insertions?