Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle    |    Overblown overpriced overengineered SHIT    |    2,288 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 601 of 2,288    |
|    Johan Hellstrom to All    |
|    Will setting BLOB to NULL free disk spac    |
|    28 Oct 03 10:34:49    |
      From: xtrnjot@nospam.hotmail.com              If a BLOB column has around 10 MB of data in it and it is set to NULL, would       the storage needed to store the record be reduced by 10 MB?              Additionally would it leave room for another 10 MB of data on the file       system? or would the DBMS still "claim" this space for another purpose?              If this is not the case, is there an alternative preferred way of freeing up       disk space used by LOB data for other purposes?              Kind Regards              Johan Hellstrom              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca