Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Merge partitions

Merge partitions

From: Mladen Gogala <mgogala.spam-me-not_at_verizon.net>
Date: Sat, 16 Dec 2006 22:57:00 GMT
Message-Id: <pan.2006.12.16.22.57.00.796587@verizon.net> 





I am doing partition merge for a table with 160 million rows and it
is taking forever (20 hours so far).


Oracle version is 10.2.0.2(RAC) on Linux x86-64, the other instance is in
restricted session mode, unavailable for all practical purposes. Does
anyone have an idea how to speed up statement like:



ALTER TABLE <tab> MERGE PARTITIONS A,B INTO PARTITION C UPDATE INDEXES?


-- 
http://www.mladen-gogala.com


Received on Sat Dec 16 2006 - 16:57:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US