how to dynamically switch accessing a table from one db to another
- From: "Giridhar" <gkodakalla@xxxxxxxxx>
- Date: 31 Mar 2007 10:09:30 -0700
Hi,
we have two databases in our production system.
these two databases gets loaded from the data from mainframes data
everyday.
Sometimes, data loading fails on one database and we switch traffic
to other database even if one table loading fails.
I would like to know if there is any way to address this:
In DB1 if one tables loading is failed, I want to configure in such a
way that any sql statement hitting DB1 should be automatically routed
to DB2. Other statements querying other tables should come to DB1
itself.
we want to modify our programs if required to achieve this
requirement.
Please advice.
Thanks
Giridhar
.
- Follow-Ups:
- Prev by Date: Re: How to do the equivalent of 'describe' with a SELECT?
- Next by Date: Re: how to dynamically switch accessing a table from one db to another
- Previous by thread: How to do the equivalent of 'describe' with a SELECT?
- Next by thread: Re: how to dynamically switch accessing a table from one db to another
- Index(es):
Relevant Pages
|
