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.