Re: Re-org of partitioned tables

From: Nag Yarlagadda <>
Date: Wed, 8 Apr 2009 13:05:25 -0700 (PDT)
Message-ID: <>

On Apr 8, 12:44 pm, Michael Austin <> wrote:
> Nag Yarlagadda wrote:
> > I have strange situation.I have table which is already partitioned by
> > range.This table has partitions upto 2007 November.And there after the
> > rest of the records are moving into MAX partition.Now we are planning
> > to split the max partition so that access of data will be more
> > ease.With huge amount of data(250 million records) in the max
> > partition its taking around 40 to 60 minutes for splitting the
> > partition.And during the process the indexes on the table are getting
> > invalid.So i am looking at better way of doing the split.Is it
> > possible to do re-org on the max partition and split it using online
> > redefinition?
> dang!! hit the send key too soon.. the docs in my previous post are for
> 11g.  (and since 10gR2 terminal release is immanent, you might want to
> start looking at 11g.)

Thanks for the reply.But the doc says that i can not split a partition in the process of re-definition.
If the partition being redefined is a range, hash, or list partition, the interim table must be non-partitioned. Received on Wed Apr 08 2009 - 15:05:25 CDT

Original text of this message