| Subject: | Oracle issue, not recovering space on LOB segments |
Hello, I'm having troubles to wipeout data on a RT 3.8.7 instance with
the Shredder Tickets plugin . Data are storaged at Oracle 10g cluster.
This is what is happening:
Lets say I send an email with a 10MB file attached.
I can see how LOB segment grows on database.
Then I do a search to found thet ticket and use Shredder to wipeout it.
When I wipeout the selected Ticket, the execution is correct, with no
error, no warnings, etc.
The database record that contains the attach content is actually
deleted.
But LOB segment don't shrinks.
I found this articles about how Oracle free assigned space:
http://www.idevelopment.info/data/Oracle/DBA_tips/LOBs/LOBS_85.shtml
I need to fix it and was wondering where is the correct place to patch
it.
Best regards
Andres