| Oracle CDC [message #211419] |
Thu, 28 December 2006 09:43  |
lotusdeva
Messages: 201
Registered: March 2005
|
Senior Member |
|
|
|
Someone in another thread suggested using Oracle's Change Data Capture as a solution to the following problem - we have 2 databases. One can potentially be down sometimes. So we replicated all 14 tables from that db - that our application uses so that if one db is down, the data from the other db is used. The problem - our users would like to refresh the data from db 2 with data from db 1 (that potentially be down) ON DEMAND. Is it possible to refresh the data on demand using Oracle's Change Data Capture? Any info would be apprciated.
|
|
|
|
| Re: Oracle CDC [message #211429 is a reply to message #211419] |
Thu, 28 December 2006 10:48  |
lotusdeva
Messages: 201
Registered: March 2005
|
Senior Member |
|
|
|
also, I forgot to ask - as our app gets the data from db 2 (which in turn is refreshed with data from db 1 upon the users request - i.e. on demand), what is the best way to ensure that the performance of our application is not affected as the data gets refreshed? Our app would be just querying the data, no inserts, updates or deletes, but is there a potential performace hit when say the user is refreshing our tables in db 1 (which the app is querying) with data from db 2? thank you!
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
