update database on daily basis.. [message #576720] |
Thu, 07 February 2013 09:16 |
lg123
Messages: 225 Registered: August 2008
|
Senior Member |
|
|
Hi,
There are 2 databases, database A and database B. Database A is Oracle 11.2.0.2 which runs on linux and Database B is Oracle 11.2.0.2 which runs on windows xp machine. In database A, there are 100's of tables which are being updated every 10 minutes or 15 minutes. For reporting purpose, the developer wants to run report for the tables. But since database A is being updated every now and then, generating reports takes almost 15 to 20 minutes. So the reports can be generated in Database B. Once in a day the database B should have the updated data from database A so that the reports can be generated in database B with less time. What could be the best solution for the database B to have the updated data on daily basis from database A in oracle?
|
|
|
|
Re: update database on daily basis.. [message #576724 is a reply to message #576723] |
Thu, 07 February 2013 09:26 |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Or to put it another way, if the reports run noticably faster on database B then there's something wrong with database A and you'd probably be better off working out what that is and fixing it.
|
|
|
|