 |
|
Oracle DBMS_REPUTIL
Oracle Tips by Burleson Consulting |
Advanced Oracle Utilities: The Definitive Reference by Rampant
TechPress is written by top Oracle database experts (Bert Scalzo, Donald Burleson, and Steve Callan). The following
is an excerpt from the book.
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.
Oracle Replication: Snapshot, Multi-master &
Materialized Views Scripts
Author: Donald K. Burleson, John Garmany, Steve
Karam
Publisher: Rampant Tech Press
ISBN: 0-9727513-3-5
ISBN-13: 978-0972751339
Replication_off is a
procedure that disables or suspends replication of changes. It has no
parameters.
Replication_on is a
procedure that enables or resumes replication of changes. It has no
parameters.
Replication_is_on is
a function that simply determines whether replication is currently
active or suspended. It has no parameters and returns a Boolean.
From_remote is a
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
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 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.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
CANON_SNAME
|
VARCHAR2
|
IN
|
|
|
CANON_ONAME
|
VARCHAR2
|
IN
|
|
Table 6.102:
Make_internal_package
Parameters
Sync_up_rep is a 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.
|
Argument
|
Type
|
In / Out
|
Default Value
|
|
CANON_SNAME
|
VARCHAR2
|
IN
|
|
|
CANON_ONAME
|
VARCHAR2
|
IN
|
|
Table 6.103:
Sync_up_rep
Parameters
|
|
|
