Adding new partition to a table
Hi,
Please see screenshot below:
We have this table AGG_DLY_STR_PROD with existing range partition on 'date_key' field (this was implemented by a 3rd party implementer). This partition is segregates data by week, and the values on HIGH_VALUE are of 7 units interval (2071, 2078, 20850)
We like to extend this partition so that DSP_WK52_2011's value is changed from MAXVALUE to 2092 and we would like to add another partition, DSP_WK53_2011 that will have MAXVALUE as its HIGH_VALUE. (this will only be initial as we plan to 'fix' the partition to reflect every week)
We think we can do this by recreating the table and adding the 'new partition' command on the create table script but it is better if we can do it without dropping and recreating the table. How can we do it, what is the best command?
Please see screenshot below:
We have this table AGG_DLY_STR_PROD with existing range partition on 'date_key' field (this was implemented by a 3rd party implementer). This partition is segregates data by week, and the values on HIGH_VALUE are of 7 units interval (2071, 2078, 20850)
We like to extend this partition so that DSP_WK52_2011's value is changed from MAXVALUE to 2092 and we would like to add another partition, DSP_WK53_2011 that will have MAXVALUE as its HIGH_VALUE. (this will only be initial as we plan to 'fix' the partition to reflect every week)
We think we can do this by recreating the table and adding the 'new partition' command on the create table script but it is better if we can do it without dropping and recreating the table. How can we do it, what is the best command?
0