OraFAQ Forum: Performance Tuning » Merge Partition into 1 single partition

Home » RDBMS Server » Performance Tuning » Merge Partition into 1 single partition

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Merge Partition into 1 single partition [message #192525]

Tue, 12 September 2006 13:48

faiz_hyd
Messages: 294
Registered: February 2006

Senior Member

Hi,

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,

Thanks

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

Report message to a moderator