How to reclaim data store space in timesten 7.0.5 database
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.
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.