Re: Tablespace shrink, HWM, interval partitionig

From: Greg Rahn <greg_at_structureddata.org>
Date: Mon, 28 Mar 2011 07:38:05 -0700
Message-ID: <AANLkTikzYxQHbJ5L7yk+KECKQe5jYyonxVPkaJcj-ytk_at_mail.gmail.com>



How about:
ALTER TABLE ... ENABLE ROW MOVEMENT;
ALTER TABLE ... SHRINK SPACE CASCADE;
http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/schema003.htm#CBBBIADA

On Mon, Mar 28, 2011 at 2:34 AM, Stefano Cislaghi <s.cislaghi_at_gmail.com> wrote:
> Hi all,
>
> I'm experiencing a problem with a tablespace.
> In this tablespace there's only a table with 30 partitions with a
> total size of about 5gb.
> The table uses interval partitiong to create a new partition for each day.
> Old partitions are removed with ALTER TABLE ... DROP PARTITION ...
>
> My tablespace is about 30gb. As HWM is at the end of tablespace I've
> tried with ALTER TABLE ... MOVE PARTITION ... without success.
> Ok I know I can export, recreate tablespace and import. Also I can
> move the table to another tablespace and move back ... but I'm looking
> for a correct solution to be used ONLINE.
>
> I'm running 11.2.0.1 on Linux. Tablespace is using LMT and ASSM.
>
> Any hint?
>
>
> Stefano

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 28 2011 - 09:38:05 CDT

Original text of this message