Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> how to dynamically switch accessing a table from one db to another
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
![]() |
![]() |