parpaa
asked on
How to reclaim data store space in timesten 7.0.5 database
Hello experts,
Lately i am having challenges with Timesten datastore space issues. I truncated one huge table consisting of 2+ millions rows and even after that i would not get the space back. I tried restarting the TT manager and that didnt work either.
The 'log purge and 'Log auto truncate' options are enabled in my DSN.
Perm size: 900 (currently sitting at 845 mb)
Temp size: 100
log file size 128
log bugger: 131072
Lately i am having challenges with Timesten datastore space issues. I truncated one huge table consisting of 2+ millions rows and even after that i would not get the space back. I tried restarting the TT manager and that didnt work either.
The 'log purge and 'Log auto truncate' options are enabled in my DSN.
Perm size: 900 (currently sitting at 845 mb)
Temp size: 100
log file size 128
log bugger: 131072
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
drop tablespace tablespace_name including contents;
This will drop the datafiles at the OS level and free up the space.
If the tablespace is NOT empty, but if it has some freespace move that object to a new tablespace and then drop the tablespace. This will help reclaiming the space.