Home » Server Options » Replication » update database on daily basis..
update database on daily basis.. [message #576720] Thu, 07 February 2013 09:16 Go to next message
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 #576723 is a reply to message #576720] Thu, 07 February 2013 09:24 Go to previous messageGo to next message
BlackSwan
Messages: 23034
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>What could be the best solution for the database B to have the updated data on daily basis from database A in oracle?

quantify "best"

which metric measures best?

I would expect reports to take 15 to 20 minutes to run on database B.
Re: update database on daily basis.. [message #576724 is a reply to message #576723] Thu, 07 February 2013 09:26 Go to previous messageGo to next message
cookiemonster
Messages: 11177
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.
Re: update database on daily basis.. [message #576731 is a reply to message #576720] Thu, 07 February 2013 10:22 Go to previous message
Michel Cadot
Messages: 59751
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can create mviews on the report database; mviews which don't need to match the original tables but the report(s) you want to generate.

Regards
Michel
Previous Topic: replication for dual schemas in same database
Next Topic: Oracle replication challenges for unique needs
Goto Forum:
  


Current Time: Sun Nov 23 18:27:11 CST 2014

Total time taken to generate the page: 0.08058 seconds