René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

dbms_repcat

This package is part of Oracle's replication management API.
In a replication environment, all DDL statements must be executed with dbms_repcat.

add_master_database

See also specifying replication group in a multimaster replication environment.

alter_master_repobject

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).

create_master_repgroup

Creates a master group.
See also defining replication group in a multimaster replication environment.

create_master_repobject

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.

create_snapshot_repgroup

generate_replication_support

See also generate replication support for replicated objects in a multimaster replication environment.

make_column_group

Must be called from the master definition site.

relocate_masterdef

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.

resume_master_activity

See also resuming replication in a multimaster replication environment.

suspend_master_activity

Alters a replication_group's replication activity status to quiesced.