Re: Tablespace shrink, HWM, interval partitionig

  • From: "Stefano" <s.cislaghi@xxxxxxxxx>
  • To: "Greg Rahn" <greg@xxxxxxxxxxxxxxxxxx>
  • Date: Mon, 28 Mar 2011 14:54:53 +0000

Sorry I've forgotten to mention, this has been already done without success

Stefano

------Original Message------
From: Greg Rahn
To: Stefano Cislaghi
Cc: Oracle L
Subject: Re: Tablespace shrink, HWM, interval partitionig
Sent: Mar 28, 2011 16:38

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@xxxxxxxxx> 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.stefanocislaghi.eu

Sent by BlackBerry® Bold 9700

Other related posts: