STATSPACK migration

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
--
http://www.freelists.org/webpage/oracle-l

Other related posts: