Deleting range partition in db2
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.
精彩评论