Archive for February, 2008
Monthly Archive
Friday, February 15th, 2008
Freeing Up Space Unused by Oracle
Oracle tablespaces can be set to auto-extend, but not to auto-contract. As a result, one can end up with a 10GB datafile that only has 10MB of stuff in it. Enterprise Manager Console and various other tools make shrinking a datafile a point-and-click operation, but remember what I said about tools? Here [...]