Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how to dynamically switch accessing a table from one db to another

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

From: Giridhar <gkodakalla_at_gmail.com>
Date: 31 Mar 2007 10:09:30 -0700
Message-ID: <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 Received on Sat Mar 31 2007 - 12:09:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US