Re: Q:Multi-Master Replication and Table Reorganization

Eric

Why remove the table from the rep group? If you can stop changes being made at the other masters, what I would do instead is:

1. Execute dbms_reputil.replication_off at each instance.
2. Export the objects from the database where the data needs reorganizing.
3. Truncate the tables.
4. Import the objects.
5. Execute dbms_reputil.replication_on on all sites.

Haven't thought through it thoroughly, but that should work. Now if you can't stop changes going on at the other masters, that's a different ballgame, but I think from memory the recommendation is to suspend replication anyway before doing this.

HTH. Pete

Eric Comeau wrote:

> How does one perform a table reorganization (export/import) in a
> Multi-Master Replicated environment (with say four master sites) without
> having the import replicate to the other sites?
>
> I have read through all the Oracle Replication manuals and there is no
> discussion of the topic under any of the "Administering a Replicated
> Environment" sections.
>
> When I posed the question to one Oracle Consultant, his answer was you
> had to remove the table from the replication group, perform the
> reorganization and then add the table in again.
>
> I have placed a call with Oracle Support and am awaiting their answer,
> but since I only have bronze support, I only expect an answer next week.
>
> Eric Comeau
> ecomeau_at_baynetworks.com

--
Regards

Pete

Received on Fri Jul 16 1999 - 11:42:27 CDT