First of all apologies, if its not the relevant forum to ask the question.
We have oracle ebs r12.1.3 with database 220.127.116.11. Our management needs to know our options, incase we have data for around 15 years and we want a split in our data i.e., we want to keep data for current 5 years and would like to have older data archived to another place or database each year at a particular month. how could we accomplish this ?
What would be the tool / technology used in this case and what would be reporting techniques on the archived data / database.
Thanks in advance