Need some pointers - how to 'update' a "data mart"
I'm not looking for complicated, state of the art solutions here guys. No-one's willing to spend money or a lot of time on this project here, so here's the spec:
We have 5 databases (ranging from Ora 8 to 10). There is a requirement to move data/tables from each into a central database for reporting purposes. Creating Mat Views is out (or may not be!) so I was thinking of a way of using the Archived Redo Logs of each to deduce the SQL/DML and periodically using these to update the central 'Mart'.
Is that idea practical? Anyone done it? Is there a better solution? It may only be updated once or twice a day.
There are fears of impacting on the performance of the source databases, so I'm not keen to do the updates via SQL and DB links.
Click Here to Expand Forum to Full Width