December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_REPUTIL.REPLICATION_OFF;
Allows you to modify tables without replicating the modification to other sites.
PROCEDURE DBMS_REPUTIL.REPLICATION_ON;
Turns replication back on.
FUNCTION DBMS_REPUTIL.REPLICATION_IS_ON
RETURN BOOLEAN;
Used to determine if replication is on. New with Oracle8i.
PROCEDURE DBMS_REPUTIL.FROM_REMOTE
RETURN BOOLEAN;
Returns TRUE at the beginning of internal replication procedures and FALSE at the end. New with Oracle8i.
PROCEDURE DBMS_REPUTIL.GLOBAL_NAME
RETURN VARCHAR2;
Returns the global database name of a local database. New with Oracle8i.
PROCEDURE DBMS_REPUTIL.MAKE_INTERNAL_PKG
(canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2);
Synchronizes internal packages with the canon_sname.canon_oname table or materialized view in replication catalog. Use this procedure only when suggested by Oracle Support. New with Oracle8i.
PROCEDURE DBMS_REPUTIL.SYNC_UP_REP
(canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2);
Synchronizes internal packages with the canon_sname.canon_oname table or materialized view in the replication catalog. Use this procedure only when suggested by Oracle Support. New with Oracle8i.