OraFAQ Forum: Replication » Syncronize database server data

Home » Server Options » Replication » Syncronize database server data (oracle 10.2, linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Syncronize database server data [message #474578]

Tue, 07 September 2010 06:22

goracle9
Messages: 136
Registered: December 2006

Senior Member

Dear all,

we have four location, four database server seperatly,

we need to syncronize all the servers.

for example. all the server gaving table parts
if the parts_count column change in server. it showuld be change all the four servers

please help me, how to syncronize

thanks

Report message to a moderator

Re: Syncronize database server data [message #474579 is a reply to message #474578]

Tue, 07 September 2010 06:27

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What are the allowed options?
Are you ready to buy additional Oracle options or products?
Or do you want to do it by custom scripts?

Regards
Michel

Report message to a moderator

Re: Syncronize database server data [message #474582 is a reply to message #474579]

Tue, 07 September 2010 06:38

goracle9
Messages: 136
Registered: December 2006

Senior Member

Please Michel

give me the both options

Report message to a moderator

Re: Syncronize database server data [message #474603 is a reply to message #474582]

Tue, 07 September 2010 08:35

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There are numerous possible options, I will not a research for you that will take me several days of work.

Here's one: Never directly change part_count in one server, use a procedure that changes it in ALL servers.

Regards
Michel

[Updated on: Tue, 07 September 2010 08:36]

Report message to a moderator