Re: Re-org of partitioned tables
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Wed, 08 Apr 2009 13:44:29 -0500
Message-ID: <pg6Dl.25697$yr3.2926_at_nlpi068.nbdc.sbc.com>
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?
Date: Wed, 08 Apr 2009 13:44:29 -0500
Message-ID: <pg6Dl.25697$yr3.2926_at_nlpi068.nbdc.sbc.com>
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.) Received on Wed Apr 08 2009 - 13:44:29 CDT