Can I use "Shrink Table" to de-allocate unused blocks after deleting LOBs in Oracle 11g Standard Edi
Hi,
I am trying to de-allocate unused space, after deleting LOBs from a table using the following command
ALTER TABLE OWNER.TABLE_NAME MODIFY LOB (COLUMN_NAME) (SHRINK SPACE);
But, It only free few megabytes of space, while I have deleted around 100GB data. Also the table is not reusing the free blocks. It gives an error that can't extend the LOB segment.
Would anybody please advise, how to de-allocate the free blocks or reuse it. Is there any limitation on 11g Standard Edition 1.
Due to insufficient Hard disk space, I can't move the whole table data to a new tablespace to reduce the tablespace size.