J
James Palmer
Guest
We have a table in our DB which has a BLOB on it. The table is in storage area A (not the real name) and the BLOB field is allocated to storage area B. Unfortunately storage area B also has a lot of other stuff in it. Bad design I know. It's on our list of fixes for the future. We have identified that a LOT of the BLOB records are in fact duplicates and have removed them. Obviously this doesn't actually free up the space the DB uses. So I'm wondering what process I need to follow in order to free up this space on disk? I'm doing a test of the process in my development environment. It should free around 25% of disk usage across the whole DB. Sorry for the basic question. My DBA experience is very minimal. Progress version 11.2.1.
Continue reading...
Continue reading...