| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> REPLICATION QUESTION - LOng and strange
Hi Listers,
alright I've exhausted almost all my resources and I
am turning to my last resource.
We have 3 databases.
Database A - OLTP Database B - OLTP Database c - DSS
ORACLE 8.1.6.3 ON HP-UX 11.0
Database A has a table which is being replicated to C
as a read only snapshot and we have long and complex
summary process (relic of 1998’s) that works off this
snapshot. Now due to some new merger same table need
to be created in database B. And yes…the data in table
B also need to be replicated to the SAME snapshot in
database C so that the summary process can summarize
the collective data. The problem is I am sure this
could be accomplished. THAT IS TWO MASTERS SITES
FEEDING SAME SNAPSHOT….!!!
I have checked the replication manual and Unless I am
so sleep deprived that I am missing lines I didn’t
find any reference to this kinda replication setup.
Any pointers welcome. I am exhausted, so if you don’t
mind, if RTFMs could refer the relevant section I am
supposed to RTFM, then it would be great. Rewriting
the summary process is not an option due to
unrealistic deadline.
TIA.
RS
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Jun 23 2002 - 13:28:18 CDT
 |
 |