René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
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_repgroupgenerate_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.
|