Does anyone has any kind of Documentation on Data Archiving.
Thanks in Advance
Could you be more specific?
(Some of ours we tie up with string, put it in cardboard boxes and keep it in the basement well it is on paper!)
I'm trying to identify the Data Archiving strategy and procedures to be used to Archive historical data from Data Warehouse, For that reason I need to understand what to look for and in genral some tips and tricks.
Partition by date range, export the old partition, then drop it.
"The Oracle Sponge"
Senior Manager, Business Intelligence Development
XM Satellite Radio
Export partition data as transportable tablespace, so you can plug it in quickly.
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams