Re: how to dynamically switch accessing a table from one db to another

On 31 Mar 2007 10:09:30 -0700, "Giridhar" <gkodakalla_at_gmail.com> wrote:

>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

1. It is not possible
2. It would be the safest route to hell
3. You should fix the problem, instead of implementing more utter crap. --

Sybrand Bakker
Senior Oracle DBA Received on Sat Mar 31 2007 - 12:14:34 CDT