We have a table, which was already have range partition (Monthly). We have partitions till this year end. We are now palnning to add partitions for next two years.
Current structure is like below.
TABLENAME PART201409
TABLENAME PART201410
TABLENAME PART201411
TABLENAME PART201412
TABLENAME PARTMAX
I am new to partitions. Please help me on how to add partitions.
Thanks,
kris