We have Oracle EBS R12 and Database 11g (220.127.116.11).
We are looking to split EBS reporting as follows:
1. Oracle Production EBS Database should only have last 2 years data
2. Oracle Reporting EBS Database should have all data since inception including what we have in current Production (as mentioned in Step 1 above)
Using ADG, we can offload reporting to other database server. However, we can not keep history of all data once it is truncated to last 2 years in Production as it will also be deleted from ADG.
Looking for practical suggestions to achieve this?
In your case, the only solution I could think of is Oracle GoldenGate.
Please review the following links for details: