Re: replication

mike7411_at_gmail.com wrote:
> I'm attempting to set up multimaster replication between two Oracle 10g
> systems like so:
>
> SQL> begin
> 2 dbms_repcat.add_master_database(
> 3 gname => 'handover_repgroup',
> 4 master => 'nct2.world',
> 5 use_existing_objects => true,
> 6 copy_rows => false,
> 7 propagation_mode => 'asynchronous');
> 8 end;
> 9 /
>
>
> Unfortunately, I keep getting this error:

My only thought is why? Advanced Replication is a dinosaur in need of a quick burial and hopefully it won't leave any fossil record. If you have 10g look into using Streams or Change Data Capture.

There is a complete demo of CDC in Morgan's Library at www.psoug.org. Far more powerful, far easier to implement, far easier to maintain, far less prone to breakage.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group