Partitioned Table Purging Live Steps
create table archive.archive_tasks partition by range (TIME) (partition ARC_Pdefault values less than (to_date(’01-10-2008′, ‘DD-MM-YYYY’)) ) as select * from tasks where 1=2 ; create table archive.partition_holder_tasks as select * from TASKS where 1=2; alter table TASKS exchange partition Pdefault with table archive.partition_holder_tasks; alter table archive.archive_tasks exchange partition arc_pdefault with table archive.partition_holder_tasks; — Adding Partition alter […]