Archiving and Cleansing Oracle Data

Question

Can someone tell me which technologies I should use to archive and clean up historical data.

Answer 1

As Justin said in his comment, this is a broad question. The broad answer is to use Oracle Partitioning . In general, this will allow you to process subsets of data using DDL (truncated, moved, or discarded partitions) instead of the more resource-intensive DML.

Answer 2

As part of the solution, you can consider table compression . This can potentially save a lot of space.