Re: Freeing up tablespace in Oracle...

From: godmann <allanwtham_at_yahoo.com>
Date: 13 Sep 2001 21:00:58 -0700
Message-ID: <95cd51c.0109132000.22191d03_at_posting.google.com>


Hi there,

   I think there is a limitation in Oracle. You cannot move the HWM manually. You can use the Truncate with the "Deallocate unused" option.
However, it will release unused blocks ABOVE the highwater mark but will not move the highwater mark itself.

   If space really a limitation to you, delete the rows according to the
age of the rows and, copy the table to a temporary table, drop the original
table, and create back the table.

  Alternatively, do a export the table and import it in again with COMPRESS=Y.   Yes, it will be nice to move HWM.

  Allan W. Tham
  DBA Received on Fri Sep 14 2001 - 06:00:58 CEST

Original text of this message