Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle Built−in Packages- P130: Ah, for the good old days of Version 1.0 of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms 3.0, and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk Locks the snapshot base tables SNAP _ tablename Regenerates replication triggers and packages for the objects in the group 14.4.4.1 The DBMS_REPCAT.ALTER_SNAPSHOT_PROPAGATION procedure Call the ALTER_SNAPSHOT_PROPAGATION procedure to change the propagation mode of a particular snapshot. Specifications for Oracle7 and Oracle8 differ as follows. Here is the Oracle7 specification PROCEDURE DBMS_REPCAT.ALTER_SNAPSHOT_PROPAGATION alter_snapshot_propagation gname IN VARCHAR2 propagation_mode IN VARCHAR2 comment IN VARCHAR2 execute_as_user IN BOOLEAN FALSE Here is the Oracle8 specification PROCEDURE DBMS_REPCAT.ALTER_SNAPSHOT_PROPAGATION gname IN VARCHAR2 propagation_mode IN VARCHAR2 comment IN VARCHAR2 Parameters are summarized in the following table. Name Description gname Name of the replication group to be altered propagation_mode The new propagation mode to use SYNCHRONOUS or ASYNCHRONOUS comment Comment visible in DBA_REPPROP data dictionary view execute_as_user Oracle7 only FALSE default indicates that remote system will authenticate calls using authentication context user who originally queued the RPC TRUE indicates that remote system will use authentication context of the session user 14.4.4.1.1 Exceptions ALTER_SNAPSHOT_PROPAGATION raises the following exceptions Name Number Description dbnotcompatible -23375 Database version is not 7.3 or later missingrepgroup -23373 Replication group gname does not exist typefailure -23319 Invalid propagation_mode 14.4.4.1.2 Restrictions ALTER_SNAPSHOT_PROPAGATION must be called from a snapshot site. 14.4.4.1.3 Example The following example shows how to switch from asynchronous to synchronous propagation for a given snapshot replication group BEGIN 14.4.4 Altering a Snapshot Replication Group s Propagation Mode 636 Appendix A What s on the Companion Disk DBMS_REPCAT.ALTER_SNAPSHOT_PROPAGATION gname SPROCKET propagation_mode ASYNCHRONOUS comment Mode set to asynchronous on sysdate by .