Choose Category
CREATE SET VOLATILE TABLE YOUR_VOLATILE_TABLE AS ( SEL * FROM YOUR_MAIN_TABLE ) WITH DATA ON COMMIT PRESERVE ROWS ;
DELETE FROM YOUR_MAIN_TABLE;
INSERT INTO YOUR_MAIN_TABLE SELECT * FROM YOUR_VOLATILE_TABLE;;