Is it possible to transfer expired data into another table ? I want to implement an efficient mechanism to transfer previous day data into weekly table, previous week data into monthly table etc.
I don't want to use multiple materialized views, to not calculate summary data for each table when new data comes.
Any design suggestion to handle this is also welcome.
