Re: Re-org of partitioned tables
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Wed, 08 Apr 2009 13:40:25 -0500
Message-ID: <Bc6Dl.25696$yr3.17607_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
Date: Wed, 08 Apr 2009 13:40:25 -0500
Message-ID: <Bc6Dl.25696$yr3.17607_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?
What version? the "correct" answer can be version dependent.
Assuming 10gR2 (preferably 10.2.0.4)
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/tables007.htm Received on Wed Apr 08 2009 - 13:40:25 CDT