Hello,
Currently Symantec has poor soultion to free space from table space.
1. Web archive- which is not 100% solution, cause:
- Admin needs to remember to put incidents into archive, there is no automatic mechanisim for this action!
2. Even when Incindets are been deleted (after archive) it does not say that you will have more space on DB, two main reason for that:
a. As above mentioned, each incindet is related to another, and if few incindets were created from same word/attachements/etc... ==> all of them (all the incidents) must be deleted in order to free some space on DB.
b. Morever, from what i understood, even if you do delete all the incindents which are related to each other ==> it is not 100% sure that Oracle DB will free the space of these incindets.
Good Luck all