"Sakthi , Raj" wrote: > > 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 >
Wouldn't it be possible to replace your current snapshot by a view, the union of one snapshot on A and one snapshot on B? C could the summarize both. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).