tailieunhanh - Oracle Built−in Packages- P131

Oracle Built−in Packages- P131: 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. | Oracle Built-in Packages SEARCH PREVIOUS Chapter 15 NEXT 641 15. Advanced Replication Contents DBMS_REPCAT_AUTH Setting Up Administrative Accounts DBMS_REPCAT_ADMIN Setting Up More Administrator Accounts DBMS_REPCAT Replication Environment Administration DBMS_OFFLINE_OG Performing Site Instantiation DBMS_RECTIFIER_DIFF Comparing Replicated Tables DBMS_REPUTIL Enabling and Disabling Replication If you are using the advanced replication option you will use Oracle built-in packages to create and maintain a replicated environment. This chapter describes packages and the roles they play in the configuration and upkeep of a multi-master environment. DBMS_REPCAT_AUTH Grants and revokes surrogate SYS privileges for an administrator account. DBMS_REPCAT_ADMIN Creates administrator accounts for replication. DBMS_REPCAT An enormous package that performs many different types of advanced replication operations. This chapter describes only the programs that deal with replication environment maintenance the other DBMS_REPCAT programs are described in Chapter 14 Snapshots and Chapter 16 Conflict Resolution. DBMS_REPUTIL Enables and disables replication at the session level. DBMSOFFLINEOG Instantiates sites -- that is lets you export data from an existing master site and import it into the new master site. DBMS_RECTIFIER_DIFF Compares the replicated tables at two master sites and allows you to synchronize them if they are different. In this chapter the presentation is more or less chronological -- the packages and their programs are presented in roughly the order in which you would run them in a real advanced replication situation. DBMS_REPCAT_AUTH Setting Up Administrative Accounts The first step in creating an advanced replication environment is to create administrative and end user accounts. The DBMS_REPCAT_AUTH and DBMS_REPCAT_ADMIN packages contain programs that grant and revoke the privileges required in such an environment. This section describes the DBMS_REPCAT_AUTH .