Home » Server Options » Replication » is it possible ? (10 R2)
is it possible ? [message #404929] Mon, 25 May 2009 09:30 Go to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
hello is is possible to use oracle replication for the following :
i have a databse in site A

and 4 database in sites B,C and D
is it possibles to use Oracle replication in order to have all tables data from sites B,C and D in relevant table in Site A,
assuming that site A tables has the site id in each of its tables

hope i was clear
thanks
Re: is it possible ? [message #404938 is a reply to message #404929] Mon, 25 May 2009 10:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'm not sure I understand what you mean but it is possible to do such things with materialized views or Streams.

Regards
Michel

[Updated on: Mon, 25 May 2009 10:01]

Report message to a moderator

Re: is it possible ? [message #405024 is a reply to message #404929] Tue, 26 May 2009 01:59 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
Thanks Michel
just to be more clear:
on site A I have a table name t1, with this structure

site id, order id . client id, date
------- -------- --------- ----
A 1 2 22-3-09
B 1 5 23-5-09
C 3 8 12-5-09

i have the same table in all other sites B,C and D
but with data only specific to the site example:

site B:
site id, order id . client id, date
------- -------- --------- ----
B 1 2 22-3-09
B 1 5 23-5-09 B 3 8 12-5-09

so what I need is to have all this data from the 3 sites B,C and D replicate in the same table t1 in site A, real time or not it does not matter
so does oracle streams solve it ?
many thanks
Re: is it possible ? [message #405050 is a reply to message #405024] Tue, 26 May 2009 03:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes you can use Streams to fit this.

Regards
Michel
Re: is it possible ? [message #405054 is a reply to message #404929] Tue, 26 May 2009 03:37 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
Many thanks Michel
but since many sites will stream to the same table at the same time, would that cause some problems on site A ? like waits...

cheers

[Updated on: Tue, 26 May 2009 03:39]

Report message to a moderator

Re: is it possible ? [message #405094 is a reply to message #405054] Tue, 26 May 2009 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No more than if there are several users inserting in the same table. It is database life to be accessed by many users at the same time and it supports thousand of them.

Regards
Michel
Re: is it possible ? [message #405130 is a reply to message #405094] Tue, 26 May 2009 07:53 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Yes; You can go with Streams Or Advanced Replication (Materialized-View based)

Babu
Previous Topic: Issue with Materialized View after 10g Upgradation
Next Topic: Upgrade
Goto Forum:
  


Current Time: Thu Mar 28 17:23:22 CDT 2024