DBMS_REPUTIL, 2 of 2

DBMS_REPUTIL Package

Summary of Subprograms

Table 41-1 DBMS_REPUTIL Package Subprograms

Subprogram	Description
REPLICATION_OFF Procedure	Modifies tables without replicating the modifications to any other sites in the replicated environment, or disables row-level replication when using procedural replication.
REPLICATION_ON Procedure	Re-enables replication of changes after replication has been temporarily suspended.
REPLICATION_IS_ON Function	Determines whether or not replication is running.
FROM_REMOTE Function	Returns `TRUE` at the beginning of procedures in the internal replication packages, and returns `FALSE` at the end of these procedures.
GLOBAL_NAME Function	Determines the global database name of the local database (the global name is the returned value).
MAKE_INTERNAL_PKG Procedure	Synchronizes internal packages and tables in the replication catalog. This procedure is executed under the direction of Oracle Worldwide Support only.
SYNC_UP_REP Procedure	Synchronizes internal triggers and tables/snapshots in the replication catalog. This procedure is executed under the direction of Oracle Worldwide Support only.

REPLICATION_OFF Procedure

This procedure lets you modify tables without replicating the modifications to any other sites in the replicated environment, or disables row-level replication when using procedural replication. In general, you should suspend replication activity for all master groups in your replicated environment before setting this flag.

Syntax

DBMS_REPUTIL.REPLICATION_OFF();

Parameters

None

REPLICATION_ON Procedure

This procedure re-enables replication of changes after replication has been temporarily suspended.

Syntax

DBMS_REPUTIL.REPLICATION_ON();

Parameters

None

REPLICATION_IS_ON Function

This function determines whether or not replication is running. A returned value of TRUE indicates that the generated replication triggers are enabled. A return value of FALSE indicates that replication is disabled at the current site for the replicated master group.

The returning value of this function is set by calling the REPLICATION_ON or REPLICATION_OFF procedures in the DBMS_REPUTIL package.

Syntax

DBMS_REPUTIL.REPLICATION_IS_ON()
  return BOOLEAN;

Parameters

None

FROM_REMOTE Function

This function returns TRUE at the beginning of procedures in the internal replication packages, and returns FALSE at the end of these procedures. You may need to check this function if you have any triggers that could be fired as the result of an update by an internal package.

Syntax

DBMS_REPUTIL.FROM_REMOTE()
   return BOOLEAN;

Parameters

None

GLOBAL_NAME Function

This function determines the global database name of the local database (the global name is the returned value).

Syntax

DBMS_REPUTIL.GLOBAL_NAME()
   return VARCHAR2;

Parameters

None

MAKE_INTERNAL_PKG Procedure

This procedure synchronizes the existence of an internal package with a table in the replication catalog. If the table has replication support, execute this procedure to create the internal package. If replication support does not exist, destroy any related internal package.

Caution:
This procedure should only be executed under the guidance of Oracle Worldwide Support.

Syntax

DBMS_REPUTIL.MAKE_INTERNAL_PKG (
   canon_sname    IN   VARCHAR2,
   canon_oname    IN   VARCHAR2);

Parameters

Table 41-2 MAKE_INTERNAL_PKG Procedure Parameters

Parameter	Description
canon_sname	Schema containing the table to be synchronized. This parameter value must be canonically defined (capitalization must match object and must not be enclosed in double quotes).
canon_oname	Name of the table to be synchronized. This parameter value must be canonically defined (capitalization must match object and must not be enclosed in double quotes).

Parameter

Description

canon_sname

Schema containing the table to be synchronized.

This parameter value must be canonically defined (capitalization must match object and must not be enclosed in double quotes).

canon_oname

Name of the table to be synchronized.

This parameter value must be canonically defined (capitalization must match object and must not be enclosed in double quotes).

SYNC_UP_REP Procedure

This procedure synchronizes the existence of an internal trigger with a table or snapshot in the replication catalog. If the table or snapshot has replication support, execute this procedure to create the internal replication trigger. If replication support does not exist, destroy any related internal trigger.

Caution:
This procedure should only be executed under the guidance of Oracle Worldwide Support.

Syntax

DBMS_REPUTIL.SYNC_UP_REP (
   canon_sname    IN   VARCHAR2,
   canon_oname    IN   VARCHAR2);

Parameters

Table 41-3 SYNC_UP_REP Procedure Parameters

Parameter	Description
canon_sname	Schema containing the table or snapshot to be synchronized. This parameter value must be canonically defined (capitalization must match object and must not be enclosed in double quotes).
canon_oname	Name of the table or snapshot to be synchronized. This parameter value must be canonically defined (capitalization must match object and must not be enclosed in double quotes).

Parameter

Description

canon_sname

Schema containing the table or snapshot to be synchronized.

This parameter value must be canonically defined (capitalization must match object and must not be enclosed in double quotes).

canon_oname

Name of the table or snapshot to be synchronized.

This parameter value must be canonically defined (capitalization must match object and must not be enclosed in double quotes).