"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: sfaroult_at_oriole.com
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 - 16:03:23 CDT
