Re: DB Size Doesn't Decrease After Dropping Tables
Hello,
The InnoDB tablespace can only grow.
Your only solution to reclaim disk space is to dump the database,
delete InnoDB tablespace and logfiles, recreate them, and reload your
database.
Before reloading the data, you can add the innodb_file_per_table to your
my.cnf so that InnoDB use a separate file for each table instead of the global
tablespace. So you can drop a table and reclaim the disk space.
Regards,
Thomas CORBIERE
Subject
Views
Written By
Posted
3535
October 06, 2007 03:41PM
Re: DB Size Doesn't Decrease After Dropping Tables
3172
October 11, 2007 05:57AM
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.