| is it possible ? [message #404929] |
Mon, 25 May 2009 09:30  |
maoro
Messages: 295
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  |
Michel Cadot
Messages: 28991
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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]
|
|
|
| Re: is it possible ? [message #405024 is a reply to message #404929] |
Tue, 26 May 2009 01:59 |
maoro
Messages: 295
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 #405054 is a reply to message #404929] |
Tue, 26 May 2009 03:37 |
maoro
Messages: 295
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]
|
|
|
| Re: is it possible ? [message #405094 is a reply to message #405054] |
Tue, 26 May 2009 05:58 |
Michel Cadot
Messages: 28991
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
