Nullable CLOB and reclaim space
Oracle database 11.2.0.3 Enterprise Edition RAC on AIX
I have a huge table (30 TB) that contains CLOB. Here are contained data since ten year ago or maybe more.
Now we can clean some data making NULL all the CLOB neither the last year.
So at the end we'll have a "small" table with a lot of empty CLOB.
The question is: if we partition the table for "year", during the partitioning the table is reorganized so we can reclaim space ?
Thanks