our customer wants to archive some historical data to another db to keep the production database small, but the historical data must be accessible as if it reside in the production database. IBM OPTIM can do this. any oracle option/features to match OPTIM?
The best way to keep your data accessible is to keep it in the database. With Oracle, you can allocate your data to the appropriate storage tiers according to your performance and cost requirements. You use the partitioning option to do this, but the cost saved by using cheap disks for your older, infrequently accessed data can more than make up for the cost of the partitioning option. And the ILM Assistant which facilitates your use of storage tiers is free.
Because of the magic of partitioning, all of your data is accessible all of the time, performance is optimized because queries that exclude the older data never look at the older partitions, and cost is minimized because you only store your hottest, most frequently used data on a minimal number of fast disks.