Re: [ADMIN] Migrating tables to new tablespace, freed up space doesn't match moved data

2013-02-20 Thread Prashanth Ranjalkar
When any files that are in large size moved out or deleted, the reclaiming of the space at certain operating system level may not be fast enough as soon as the operation is completed and may take time.. Another possibility would be that stats are not updated, worth to analyze the tables that are m

[ADMIN] Migrating tables to new tablespace, freed up space doesn't match moved data

2013-02-20 Thread Brian Fehrle
Hi all, I've set up a tablespace on a different partition from the main data directory. I moved a few tables and indexes over to the new tablespace and the disk space used in this new tablespace doesn't match the amount of data 'freed up' from the main data directory. The tablespace is sittin