Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

52
DBMS_REPUTIL

DBMS_REPUTIL contains subprograms to generate shadow tables, triggers, and packages for table replication, as well as subprograms to generate wrappers for replication of standalone procedure invocations and packaged procedure invocations. This package is referenced only by the generated code.

This chapter discusses the following topics:

Summary of DBMS_REPUTIL Subprograms

Table 52-1 DBMS_REPUTIL Package Subprograms
Subprogram  Description 

"REPLICATION_OFF Procedure" 

Modifies tables without replicating the modifications to any other sites in the replication 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.

Note: Do not execute this procedure unless directed to do so by Oracle Support Services. 

"SYNC_UP_REP Procedure" 

Synchronizes internal triggers and tables/materialized views in the replication catalog.

Note: Do not execute this procedure unless directed to do so by Oracle Support Services. 


Go to previous page Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback