tablespace size on windows platform
After truncating a very large table in an innodb tablespace, is the innodb file size dynamically reduced?
I am being told that in order to perform "maintenance on a database hosted off-site" that the db is being dumped, the database deleted and re-created, in order to defragment the database and recover disk space.
Is all that really necessary?
Any thought are GREATLY appreciated.
Michael.
Subject
Views
Written By
Posted
tablespace size on windows platform
4448
January 24, 2005 11:04AM
2675
January 24, 2005 11:44AM
2653
January 24, 2005 01:18PM
2614
January 26, 2005 07:56AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.