Tuesday, January 15, 2008

Merging partitions

This week i have to merge a huge number of tables partition into one yearly partition per table.

Steps :

1) Create new tablespace for yearly partition.

2) Merge all tables partitions

3) Rebuild unusable local indexes

4) Gather new partition statistics

No comments:

Post a Comment