Can anyone please tell me what tech should i use for archiving & purging the historic data.
+2
A:
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.
dpbradley
2010-10-07 10:47:18
Partitioning will also allow you to set different physical attributes for the archived partitions. For example, if you rarely update the archived data you can set PCTFREE to 0 instead of the default of 10, and save 10% on space. And you might want to consider a larger block size for the archived partitions (this could help with compression, and maybe slightly reduce the amount of overhead).
jonearles
2010-10-08 14:14:49
A:
As part of the solution you might want to consider table compression. It can potentially save a lot of space.
jonearles
2010-10-08 04:13:10