David Griffiths writes: >Oracle cannot shrink datafiles (same idea as InnoDB datafiles) when data >is deleted either.
Actually, Oracle has been able to resize data files since 7.2. It is usually done with an 'alter tablespace ... coalesce' followed by an 'alter tablespace datafile ... resize nM' command. But the resize will choke on a datafile with active extents in that datafile. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]