tag:blogger.com,1999:blog-16959946.post4109683230618884680..comments2023-12-09T16:44:47.897+01:00Comments on The Data Charmer: Partitioning with non integer values using triggersGiuseppe Maxiahttp://www.blogger.com/profile/15801583338057324813noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-16959946.post-82891195314167973272009-09-17T06:34:28.139+02:002009-09-17T06:34:28.139+02:00The functionality I'd like to see is renaming ...The functionality I'd like to see is renaming without reorganizing it. If you have a range part'd table and your last one is a maxvalue partition, it seems like you should be able to something like this<br /><br />ALTER TABLE ex RENAME PARTITION ex_maxvalue TO ex_20090915, ADD PARTITION ex_maxvalue VALUES LESS THAN MAXVALUE;<br /><br />In other words, it should work like table renaming. Doing a REORGANIZE locks the table while the data is being shuffled, which is operationally disruptive.Anonymousnoreply@blogger.com