home bbs files messages ]

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