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
Oracle DatabaseDatabases
Last Comment
sventhan
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.