Oracle7 Server Distributed Systems Volume II: Replicated Data

New and Changed Procedures

Changes to Support Table Comparison

This section describes the procedures that have been added to support the table comparison feature.

Procedure Name For More Information
dbms_rectifier_diff.differences
dbms_rectifier_diff.rectify

Table A - 3. DBMS_RECTIFIER_DIFF Procedures

Changes to Support Object Groups

This section lists the procedures in the DBMS_REPCAT package whose syntax has changed to support the addition of object groups. Each of these procedures used to take a schema name as an argument; they now take an object group name.

Procedure Name
add_master_database
remove_master_databases
create_master_repobject
alter_master_propagation
execute_ddl
comment_on_repgroup
comment_on_repsite
create_master_repgroup
create_snapshot_repgroup
generate_snapshot_support
suspend_master_activity
resume_master_activity
relocate_masterdef
purge_master_log
wait_master_log
do_deferred_repcat_admin
repcat_import_check
switch_snapshot_master
create_snapshot_repobject
define_priority_group
comment_on_priority_group
drop_priority_group
add_priority_type
alter_priority_type
alter_priority
drop_priority
drop_priority_type
define_site_priority
comment_on_site_priority
drop_site_priority
add_site_priority_site
alter_site_priority_site
alter_site_priority
drop_site_priority_site

If you were using positional notation, the sname parameter has been replaced by the gname parameter. For example, if you made the following call to suspend replication activity:

DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY('acct');

You would now be suspending replication activity for the ACCT replicated object group, as opposed to the ACCT replicated schema.

If you are using named notation, your procedures will continue to work. The procedures accept the schema name as an argument, but use the schema name as an object group name. For example, if you made the following call to suspend replication activity:

DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY(sname => 'acct');

Oracle would continue to recognize the SNAME parameter to this procedure; however, it would treat it as an object group name. You would now be suspending replication activity for the ACCT replicated object group, as opposed to the ACCT replicated schema. The complete interface to this procedure is as follows:

DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY(sname IN VARCHAR2 := '',
                                    gname IN VARCHAR2 := '');

You must supply either an SNAME or a GNAME for this procedure to work. Either argument will be interpreted by Oracle as a group name. Although Oracle continues to accept the SNAME parameter, if you are using named notation, you should update your scripts to refer to GNAME where appropriate.

Certain procedures require both a schema name and an object group name. If you do not supply both, the object group name defaults to be the same as the schema name.

Changes to Support Synchronous Replication

This section lists the new and changed procedures in the DBMS_REPCAT package that are used to support synchronous replication.

Procedure Name
alter_master_propagation
add_master_database
alter_snapshot_propagation
create_snapshot_repgroup

Procedure Name	For More Information
`dbms_rectifier_diff.differences`
`dbms_rectifier_diff.rectify`