Home » Server Options » Streams & AQ » Initial data synchronization (Oracle 11g)
Initial data synchronization [message #477772] Mon, 04 October 2010 06:53 Go to next message
art55
Messages: 2
Registered: October 2010
Location: Armenia
Junior Member
Hi,

I'm new in Oracle Streams. Anyone knows how I can synchronize my initial data from source database to destination database? I mean is there any possibility to synchronize schemes before any DML apply?

[Updated on: Mon, 04 October 2010 06:56]

Report message to a moderator

Re: Initial data synchronization [message #477812 is a reply to message #477772] Mon, 04 October 2010 09:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is explained in details in the documentation: http://tahiti.oracle.com

Regards
Michel
Re: Initial data synchronization [message #477879 is a reply to message #477812] Tue, 05 October 2010 01:09 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Hi - the package DBMS_COMPARISON has procedures for comparing objects at different sites and converging them if necessary. If you already have capture rules set up, the CONVERGE procedure will let you set tags to prevent cycling changes.
Re: Initial data synchronization [message #478111 is a reply to message #477879] Wed, 06 October 2010 06:03 Go to previous message
art55
Messages: 2
Registered: October 2010
Location: Armenia
Junior Member
Thanks!

Art
Previous Topic: Same Queue with Multiple Payloads
Next Topic: Messaging Gateway Question
Goto Forum:
  


Current Time: Fri Mar 29 02:33:44 CDT 2024