DW DB Maintenance Work Without Archiving Solution
What is the regular maintenance work a DBA should perform on DW DB?
Go thru some notes and understand moving old and history data to cheapest storage and purge data once the retention period is over is one of the strategy. I'm thinking of moving those old data by either alter the partition if there is or alter datafile, exp/imp. Other than this, is there any document stated how should it be carried out and the best practise to maintain DW DB without any archiving solution in the market? How often should it be carried out with such maintenance work?