tailieunhanh - Oracle Built−in Packages- P138

Oracle Built−in Packages- P138: 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 Restrictions Note the following restrictions on calling GENERATE_REPLICATION_TRIGGER You must call this procedure from the master definition site. The replication group must be quiesced. The GENERATE_REPLICATION_SUPPORT or GENERATE_PACKAGE_SUPPORT must previously have been called for the object specified in the oname parameter. Examples The simplest invocation of the GENERATE_REPLICATION_TRIGGER procedure does the most work this call generates replication triggers for all replicated tables at all master sites BEGIN gname SPROCKET END This next example generates replication triggers for the replicated table at all master sites BEGIN gname SPROCKET oname PRODUCTS END The following call generates replication triggers for all replicated tables in the SPROCKET replication group at the master sites and BEGIN gname SPROCKET master_list END The following call regenerates the replication support for all objects in replication group SPROCKET at all master sites EXECUTE gname SPROCKET For an additional example see the file on the companion disk. The example lists all objects in the database with a status of INVALID and generates the appropriate SQL statements to attempt to validate them. Adding and Removing Master Sites with DBMS_REPCAT Now you have generated replication support for those objects you intend to replicate and you are ready to add master sites to your environment. In advanced replication parlance a master site is a database instance where replicated objects and their replication support triggers and packages exist. Master sites are sometimes called peers because every master site has the same objects and identical or nearly .