STATSPACK migration
- From: "Srikanth Kalluri" <SKalluri@xxxxxxxxx>
- To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 24 Mar 2006 09:55:28 -0800
Hi,
I am planning to migrate the STATSPACK data from PRODUCTION databases off to a
seperate REPOSITORY -- so that I can generate reports off of the REP database.
I considered Materialized Views with a fast refresh, but didn't want to lose
historical data (PROD snapshots are purged every 2 months).
I am considering the exp with query (where snap_id = :max_snap_id) after every
snapshot, but about 5 tables don't have this SNAP_ID column. So I'd have to
figure out a way to bring them across.
Are there are tried & tested methods to achieve this goal?
Any input/recommendation is appreciated.
Thanks,
SK
--
//www.freelists.org/webpage/oracle-l
Other related posts:
