Dynamic PPI in TD13.1

Database

Dynamic PPI in TD13.1

Hi All,

I have a query regarding PPI in TD13.1 .

I have a table which is going to have 1 yr data and it is having partition on monthly interval.
while creating the table i have used the current date and add month -12 to define 12 partition.

i want when i am going to load the data of 13th month the 1st month partition will automatically get deleted and the 12 partition will rearranged from 2 to 13 (12 partition) dynamically.

it is possible in TD 13.1 or any higher version.

Many thanks in advance
1 REPLY

Re: Dynamic PPI in TD13.1

I found the solution
the command for this is

alter table tablename to current with delete ;

..... Thanks