Hi,
I have a partition in a table with value of 2009-08-01 to 2010-12-01. As you can see, my table will be "full" by the end of this year. I meant, no more partitions. I know I can use the switch option to move out some old data, but we still need the information because we need to do some statistics and the partition will help in my queries.
what I need to do to add/modify partitions in my current table? let me know if you need more specific information.
I appreciate the help !