Oracle Data Archiving & Purging
Can anyone please tell me what tech shoul开发者_如何学JAVAd i use for archiving & purging the historic data.
As Justin said in his comment this is a broad question. A broad answer is to use Oracle Partitioning. In general this will allow you to treat subsets of data with DDL (truncating, moving, or dropping partitions) instead of more resource-intensive DML.
As part of the solution you might want to consider table compression. It can potentially save a lot of space.
精彩评论