开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜