Skip to Main Content
Oracle Built-in Packages
book

Oracle Built-in Packages

by Steven Feuerstein, Charles Dye, John Beresniewicz
May 1998
Intermediate to advanced content levelIntermediate to advanced
956 pages
30h 12m
English
O'Reilly Media, Inc.
Content preview from Oracle Built-in Packages

DBMS_REPUTIL: Enabling and Disabling Replication

Situations will arise when you need to perform DML on a replicated table without propagating the changes to other master sites. For example, if you have resolved a conflict and wish to update a row manually, you would not want to propagate your change. Or you might have a trigger on a replicated table that you want to fire only for updates that originate locally. The DBMS_REPUTIL package allows you to control whether updates propagate for the current session.

Getting Started with DBMS_REPUTIL

The DBMS_REPUTIL package is created when the Oracle database is installed. The dbmsgen.sql script (found in the built-in packages source directory, as described in Chapter 1) contains the source code for this package’s specification. This script is called by catrep.sql, which must be run to install the advanced replication packages. The script creates the public synonym DBMS_REPUTIL for the package and grants EXECUTE privilege on the package to public. All Oracle users can reference and make use of this package.

Table 15.7 lists the programs available in this package.

Table 15-7. DBMS_REPUTIL Programs

Name

Description

Use in SQL?

REPLICATION_OFF

Turns replication off for the current session

No

REPLICATION_ON

Turns replication on for the current session

No

DBMS_REPUTIL Interface

This section describes the programs available in the DBMS_REPUTIL package.

DBMS_REPUTIL.REPLICATION_OFF procedure

The REPLICATION_OFF procedure works by setting ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Databases

Oracle Databases

O'Reilly Media, Inc.
Learning Oracle PL/SQL

Learning Oracle PL/SQL

Bill Pribyl, Steven Feuerstein

Publisher Resources

ISBN: 1565923758Supplemental ContentCatalog PageErrata