DBMS_REPUTIL Tips

DBMS_REPUTIL

The dbms_reputil package provides some very basic, yet key, functions and procedures for supporting replication. Replication has many behind the scenes or shadow tables, triggers and packages that are generated to coordinate and perform the actual replication work. This package contains support subprograms called by that generated code.

Even though dbms_reputil may look rather simple with just seven procedures and functions, the concept of replication and what can be done is much more complex than can be elaborated here. Thus, the following book is highly recommended where the authors do an excellent job of detailing every aspect of Oracle database replication.

Replication_off is a dbms_reputil procedure that disables or suspends replication of changes. It has no parameters.

Replication_on is a dbms_reputil procedure that enables or resumes replication of changes. It has no parameters.

Replication_is_on is a dbms_reputil function that simply determines whether replication is currently active or suspended. It has no parameters and returns a Boolean.

From_remote is a dbms_reputil function that brackets the internal replication packages so that they return TRUE when initiated, and FALSE when they complete. Think of this as a replication semaphore of types. For example, the DBA may need to code her triggers to ignore, not fire, when the update is due to replication. It has no parameters and returns a Boolean.

Global_name is a dbms_reputil function that simply returns a character sting containing the global database name. It has no parameters and returns a VARCHAR2.

Make_internal_package is a dbms_reputil procedure that synchronizes internal replication packages against the replication catalog for that table or materialized view. Do not run this procedure unless directed to do so by Oracle Support.

Table 6.102:  Make_internal_package Parameters

Sync_up_rep is a dbms_reputil procedure that synchronizes internal replication triggers against the replication catalog for that table or materialized view. Do not run this procedure unless directed to do so by Oracle Support.

Table 6.103:  Sync_up_rep Parameters

Get the Complete Oracle Utility Information  The landmark book "Advanced Oracle Utilities The Definitive Reference"  contains over 600 pages of filled with valuable information on Oracle's secret utilities. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.