Hi All,
We're exploring our options to use Logical Standby DB as a reporting purpose for EBS.
We would like to know how we can keep historical data along with current data in reporting DB while we need to remove historical data from our Production DB.
e.g. we plan to delete data from 2010 to 2013 in Production so that it would have data from 2014 till now...
We need to have a reporting DB with all data since 2010.
Is this possible to achieve?
Thanks.