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