Oracle can shrink tablespaces, you can find how to do it searching Metalink for this article: "1029252.6 How to Resize a Datafile"
Best regards, Antonio Delgado. -----Original Message----- From: David Griffiths [mailto:[EMAIL PROTECTED] Sent: martes, 03 de agosto de 2004 22:00 To: [EMAIL PROTECTED] Subject: Re: InnoDB TableSpace Question Oracle cannot shrink datafiles (same idea as InnoDB datafiles) when data is deleted either. David Marc Slemko wrote: >On Tue, 3 Aug 2004 12:42:03 -0400 , David Seltzer <[EMAIL PROTECTED]> wrote: > > >>Thanks Marc, >> >>Is there really no way to reclaim unused space in an InnoDB table >>space? If not, why is this not considered a tremendous limitation? >> >> > >Some do consider it a tremendous limitation. It all depends on how it >is being used. > >Oh, and one thing I forgot... in newer 4.1 versions, if you set things >up so each table has its own file with "innodb_file_per_table", then I >think if you do an optimize table it will end up shrinking the file for >that table since it will recreate it. However that really is just a >workaround, and there are a lot of disadvantages to that method ... >especially the fact that free space is now per table instead of per >tablespace. > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -------------------------------------------------------------------------------------- This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. No confidentiality or privilege is waived or lost by any wrong transmission. If you have received this message in error, please immediately destroy it and kindly notify the sender by reply email. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Opinions, conclusions and other information in this message that do not relate to the official business of Ydilo Advanced Voice Solutions, S.A. shall be understood as neither given nor endorsed by it. -------------------------------------------------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
