RE: partition merging

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 23 Aug 2000 11:39:34 -0400
Message-Id: <10598.115389@fatcity.com>

What about:
1- creating a regular table with the same defined indexes. 2- Exchange the big partition (including indexes) with the newly created table w/o validation.

3- Bulk insert from the small partition to the newly created table.
4- Drop the two partitions.
5- Create a new partition with the new range (the range covering the two

deleted partitions).
6- Exchange back the created table with the empty partition including indexes w/o validation.

Hope it helps,

Waleed

-----Original Message-----
From: mteehan_at_erggroup.com [mailto:mteehan_at_erggroup.com] Sent: Monday, August 21, 2000 11:04 PM
To: Multiple recipients of list ORACLE-L Subject: partition merging

Hi Folks
I am considering using partition merging for my range partitions. I have a table with two date based range partitions : "today" and "previous", each with a local prefixed index. Each day I want to merge today to previous, and create a new today partition (Previous will eventually have about 400million records, each today has about 10million). Question : does a merge rebuild BOTH partitions being merged, or just add the second partition to the first? My reading of the doco says it rebuilds both, which seems silly - it has to move 400 million records about when it only really needs to move 10million. Rebuilding the local index partitions is not something that I can avoid, but I dont want to have to re-read and copy the entire large partition every day. Do I understand this correctly - anyone else out there using partition merge - or is there another way to do this?
(p.s. I cannot run with multiple daily partitions for memory reasons.
Environment is 8162 OPS on solaris 2.6).

tia
Mark Teehan

• ERG Group -------------------------- The contents of this email and any attatchments are confidential and may only be read by the intended recipient.

  ---

-- 
Author: 
  INET: mteehan_at_erggroup.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Wed Aug 23 2000 - 10:39:34 CDT