Re: Re-org of partitioned tables
From: Nag Yarlagadda <ynagarjuna_at_gmail.com>
Date: Wed, 8 Apr 2009 13:05:25 -0700 (PDT)
Message-ID: <f9eb8ae8-e4a0-4bfb-8f5c-e2625e09a6b4_at_v28g2000vbb.googlegroups.com>
On Apr 8, 12:44 pm, Michael Austin <maus..._at_firstdbasource.com> 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.)
Date: Wed, 8 Apr 2009 13:05:25 -0700 (PDT)
Message-ID: <f9eb8ae8-e4a0-4bfb-8f5c-e2625e09a6b4_at_v28g2000vbb.googlegroups.com>
On Apr 8, 12:44 pm, Michael Austin <maus..._at_firstdbasource.com> 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