We have an 8.1.7 DSS database and a 9.2.0.7 adhoc/reporting/csv feed
database which is based on the 8.1.7 database. We use a combination of
exp/imp,materialized views and the application itself to update the data.
The breakdown is generally like this.
- exp/imp - big tables ie > 4Gb that can be loaded over night.
- mat views - smaller tables that can either be lumped together and
refreshed all at once or tables that a user can manually refresh when
required.
- application - we'll add an insert into the adhoc database across the
database link from the application on the dss side. This is for data that
needs to be in reporting as soon as finished on the dss. It's at the end of
the code so it doesn't impact the main processing.
Mike
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 21 2006 - 07:20:11 CST
