RE: Tablespace shrink, HWM, interval partitionig

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <adar666@xxxxxxxxxxxx>
  • Date: Thu, 31 Mar 2011 16:24:25 -0400

Earlier I missed the bit about dropping your older partitions. If you just
start making the new partitions in a new tablespace pretty soon the large
one will be empty and you can drop it.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Yechiel Adar
Sent: Thursday, March 31, 2011 5:47 AM
Cc: Oracle L
Subject: Re: Tablespace shrink, HWM, interval partitionig

Due to the small amount of data I think that allocating a new, smaller,
tablespace and finding a window to move the partitions to a new tablespace
is an option, but you live there, I do not.
I think it depends about the total number of partitions, but in your case I
would try to allocate a new, smaller, tablespace and change the table
definition to allocate the new partitions in the new tablespace. 
Over time this will empty out the old tablespace.

Yechiel Adar
Israel


On 28/03/2011 11:34, Stefano Cislaghi 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 ...
>
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2011