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

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 01 Apr 2007 03:44:14 GMT
Message-ID: <iUFPh.116124$p17.115010@newsfe11.phx>

"Giridhar" <gkodakalla_at_gmail.com> wrote in news:1175360970.781706.75580 @n76g2000hsh.googlegroups.com:

> 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
>

See response posted here: http://www.orafaq.com/forum/t/79284/74940/ Received on Sat Mar 31 2007 - 22:44:14 CDT