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 -- //www.freelists.org/webpage/oracle-l