How to avoid that ALTER TABLE ... MOVE PARTITION moves data
371882Mar 6 2005 — edited Mar 14 2005Hi,
I know, the question is stupid since ALTER TABLE MOVE PARTITION means moving data.
But our system is based on a partitioned table which is dynamically altered. On daily basis the lower partition is droped, the remaining partitions are shifted downward using MOVE PARTITION and the higher new partition is created. The system works fine but I forgot a detail: that MOVE PARTITION moves also the data. And since there are lots of GB, you can imagin the head of production guys.
So, please help me keep my reputation honest and let me know how can I reuse precreated tablespaces in order to drop and create dynamically partitions, given that the 1st partition has to be assigned to the 1st tablespace, the 2nd to the 2nd tablespace, etc.
Many thanks in advance for your suggestions.
Kind regards,
Nick