开发者

Deleting range partition in db2

开发者 https://www.devze.com 2023-03-23 10:15 出处:网络
I have a db2 table which was originally created with range partitioning on two of t开发者_高级运维he columns, but now I feel it unnecessary to have the range partitioning.

I have a db2 table which was originally created with range partitioning on two of t开发者_高级运维he columns, but now I feel it unnecessary to have the range partitioning. How do I remove range partitioning from the table without deleting the data already present in it.


I'm afraid you can't do that (other than creating a new table without the partitions and copying all the data over there - this can be tricky if you have foreign key constraints...).

This is one of those DB2 concepts where you have to decide what you want at creation time.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号