Home » RDBMS Server » Performance Tuning » Merge Partition into 1 single partition
Merge Partition into 1 single partition [message #192525] Tue, 12 September 2006 13:48 Go to next message
Messages: 294
Registered: February 2006
Senior Member

i have some 7 partition tables,
and in all tables partition name is like P_YYYYMM

for example
 partition P_199701 values less than (TO_DATE('19970201','YYYYMMDD')) tablespace APP_DATA_Y07;

Now in all these tables in the year 1997, 1998 and 1999 very less data is there therefore i am planning to merge the 12 partitions of each year into 1 single partition like

 alter table SITE merge partition P_199701,P_199702 into P_199712;

Here it will say P_199712 partition name already exist,
I want to give the new name P_199712 to single merged partition coming from merging 12 paritions on 1997, same like this for 199812 and 199912.

if i issue this
 alter table SITE merge partition P_199711,P_199712 into P_199712;

It works and P_199711 and P_199712 are mereged into single partition P_199712
Now we can't for other remaining partitions,

How can i merge now all the partitions 12 monthly partition into 1 for these 3 years for 7 tables, any dynamic scripts
or way to extract or 1 table at a time,


[Updated on: Tue, 12 September 2006 13:49]

Report message to a moderator

Re: Merge Partition into 1 single partition [message #192570 is a reply to message #192525] Tue, 12 September 2006 21:23 Go to previous message
Messages: 121
Registered: August 2006
Senior Member
Try merging 199701 to 199702 and then 199702 to 703 and work way up from lowest partition for that year.

Previous Topic: sql_trace question
Next Topic: help with coming up a test case!
Goto Forum:

Current Time: Tue Oct 25 11:15:24 CDT 2016

Total time taken to generate the page: 0.11612 seconds