|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
This package is part of Oracle's replication management API.
In a replication environment, all DDL statements must be executed with dbms_repcat.
See also specifying replication group in a multimaster replication environment.
This precedure can be used for ddl statements on a replication object.
If this procedure is used, the replication group should be quiesced (see suspend_master_activity). After doing the ddl, replication support must be regenerated for the object (generate_replication_support and the replication group's replication activity set back to normal (resume_master_activity).
Creates a master group.
See also defining replication group in a multimaster replication environment.
Adds an object (such as a table) to a master group.
See also add an object to a master group in a multimaster replication environment.
See also generate replication support for replicated objects in a multimaster replication environment.
Must be called from the master definition site.
This procedure can be used to relocate the master definition site.
The parameter include_old_masterdef should be set to true if the current master definition site is available, and be set to false, if it is not available.
This procedure can be called when the replication status is normal, hence no need to quiesce the replication status.
See also resuming replication in a multimaster replication environment.
Alters a replication_group's replication activity status to quiesced.