Hi all,
I know that there are a lot of discussions regarding this issue, but what I am asking here is not a single solution, but a list of possible methods to reclaim the space occupied by LOBs.
I have a Standalone Database EE version 10.2.0.5 on Windows Server 2003. The DB saves the LOB files (in BLOB and LOB format) on a single Big File Tablespace (about 3 TB)
Since we are running out of space, we need to find an effective, and possibly not too time consuming, way to reclaim the space we are going to free while cancelling the old LOB files.
I am well aware of the command "ALTER TABLE <table_name> MODIFY LOB (<lob column>) (SHRINK SPACE);", but as far as I know, it is extremely slow, so freeing something like 1TB of space could take a huge amount of time while not allowing anyone to work on the DB.
Do you have other suggestions, methods, workarounds I could use to recover the unused space? I don't need to free actual disk space, I just need Oracle to reuse the freed space!
Thank you all in advance!