mah_j (5/4/2013)
I want to archive the data of a 400G table,what is the best way of archiving?
What's the reason behind "archiving" if as I understand it, all data would be online all the time?
Either way, I agree with the previous poster - this might be a case for table partitioning, range partition by date, perhaps one partition per year.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.