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