tailieunhanh - Oracle Built−in Packages- P139

Oracle Built−in Packages- P139: Ah, for the good old days of Version 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 , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk The specifications differ for Oracle and Oracle8 as follows. Here is the Oracle specification PROCEDURE gname IN VARCHAR2 old_masterdef IN VARCHAR2 new_masterdef IN VARCHAR2 notify_masters IN BOOLEAN TRUE include_old_masterdef IN BOOLEAN TRUE sname IN VARCHAR2 Here is the Oracle8 specification PROCEDURE gname IN VARCHAR2 old_masterdef IN VARCHAR2 new_masterdef IN VARCHAR2 notify_masters IN BOOLEAN TRUE include_old_masterdef IN BOOLEAN TRUE Parameters are summarized in the following table. Name Description gname Name of the replication group. old_masterdef Global name of the current master definition site. new_masterdef Global name of the new master definition site. notify_masters If TRUE the default synchronously multicast information about the change to all masters if FALSE do not inform masters. include_old_masterdef If TRUE the default notify current master definition site of the change. sname Oracle only Not used. Exceptions The RELOCATE_MASTERDEF procedure may raise the following exceptions Name Number Description commfailure -2331 Unable to communicate with master site s and notify_masters is TRUE nonmaster -23313 The new_masterdef is not a master site nonmasterdef -23312 The old_masterdef is not the master definition site Restrictions You must call RELOCATE_MASTERDEF from a master or master definition site. Example The following call relocates the master definition site for replication group SPROCKET from to and informs all masters as well as the master definition site of the change BEGIN gname SPROCKET old_master_def Adding and Removing Master Sites with DBMS_REPCAT 681 Appendix A What s on the Companion Disk new_master_def notify_masters TRUE include_old_masterdef TRUE END Suppose that the master definition site .