Hi All,
I have a question about diverting queries (just retriving of data) to standby databsse.
F.ex I have a aplication which process patients data.
Application has one Reports module. I want these reports to point to standby database as there no UPDATE/DELETE/INSERT operation. So If I MOUNT my standby database in READ-ONLY mode, I will able to do this, then this can be achived.
Question is:
How do I divert ***only*** Reporting Module to Standby database?
Do I have to use to two differnt connections.. one will point to Live DB and other will point to STDB.. Does this mean division of application?
Thanks
Sameer