I wonder about managing table partitons.
If the table “test” partitioned, Could I add partiton more?
like "alter table test add partition less than … "
I wonder could I truncate single partiton.
I want to manage the partiton for current data, old data seperatly.
I have to delete old data. so I want truncate single partition stored old data speedy.