Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!195.208.113.67.MISMATCH!goblin1!goblin.stu.neva.ru!newsfeed.stanford.edu!newshub.sdsu.edu!flph200.ffdc.sbc.com!prodigy.net!flph199.ffdc.sbc.com!prodigy.com!flpi107.ffdc.sbc.com!nlpi068.nbdc.sbc.com.POSTED!28110ad8!not-for-mail From: Michael Austin User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070802 SeaMonkey/1.1.4 MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Re-org of partitioned tables References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Lines: 16 Message-ID: NNTP-Posting-Host: 69.148.246.154 X-Complaints-To: abuse@prodigy.net X-Trace: nlpi068.nbdc.sbc.com 1239216277 ST000 69.148.246.154 (Wed, 08 Apr 2009 14:44:37 EDT) NNTP-Posting-Date: Wed, 08 Apr 2009 14:44:37 EDT Organization: at&t http://my.att.net/ X-UserInfo1: Q[R_PJSCTS@QR\D[ZJIXOQAA\R\V@E\MNP\@NDEMCH]VGBIGFWMUCS_]^O\DXUCKV^EYZEFNG^YPNLSCZNSW^UDDENTEX\DH[X[DRVW@^DSN@GX\BSBVX\O@@LG_JBRMML^SZOBMRY]SGDOR@LXINHK_ZCX@VQKI^QYGQLOATSGFAUXE_\FPMQ\GX^RAQU^M Date: Wed, 08 Apr 2009 13:44:29 -0500 Xref: news.cambrium.nl 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.)