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.

This is an application problem, not a database problem. If you need this logic, make the failover happen in app. But as Sybrand says, better just fix the load. .......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Tue Apr 03 2007 - 10:25:59 CDT