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