hii

could anyone please suggest industry standards for archiving.

i have a banking application, and the trnsaction and movements table grows rapidly. i thought of using parttions and then dropping partitions fater taking backup. since after every first drop i should change the partition logic please suggest as to how i should accomplish this. i want to use date as the constraint for partition.

please suggest other techniques for archiving huge data.