Hi.
I've been testing how the CLOB columns work (relative to disk space ).
I've tried erasing data from a couple of columns with CLOB data type (it seems VARCHAR and the other LOBs work in the same way).
I see there is no change about the size on disk occupied by the table.
Even if I reorganize the file, the size of file remains.
If I delete records, and then REORGANIZE, yes, it affects the size on the disk.
My question is: is there anyway to reclaim space unused on disk by LOB columns in a table? (other option different to deleting records and reorganize teh file).
Thanks a lot
I've been testing how the CLOB columns work (relative to disk space ).
I've tried erasing data from a couple of columns with CLOB data type (it seems VARCHAR and the other LOBs work in the same way).
I see there is no change about the size on disk occupied by the table.
Even if I reorganize the file, the size of file remains.
If I delete records, and then REORGANIZE, yes, it affects the size on the disk.
My question is: is there anyway to reclaim space unused on disk by LOB columns in a table? (other option different to deleting records and reorganize teh file).
Thanks a lot
Comment