1 Reply Latest reply on Mar 25, 2016 12:39 PM by Bashar.

    How to setup EBS reporting DB with all data since inception and keep only 2 years EBS Data in Production

    Safi Qadri

      Hi there,

       

      We have Oracle EBS R12 and Database 11g (11.2.0.4).

       

      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?

       

      Thanks.