How to reclaim LOB column occupied space on table space?
Hello,
As most of you know once we allocate BLOB( in my case) column assign the table with in same table space, delete operation doesn't free up the space on tablespace.
even it doesn't show on dba_segments view as well.
ever one can see the space is there but even though we got the ORA-01653: unable to extend table
environment is 10gR2. on AIX
in my shop we are not using ASM. ( where I can't use shrink option too)
I have a work around that we can delete/ truncate the table and recreate it ... but I can't do that on production.
0