tailieunhanh - Oracle Built−in Packages- P135

Oracle Built−in Packages- P135: 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 replication group must already exist and be quiesced. Examples The following call removes table from the SPROCKET replication group but preserves the table BEGIN sname SPROCKET oname PRODUCTS type TABLE END Dropping a table from a replication group automatically drops all replication triggers associated with the table and removes it from the replication data dictionary views. The DROP_MASTER_REPOBJECT procedure can remove the object from the replication group and also drop the object from the schema by setting the drop_objects parameter to TRUE as shown in this example BEGIN sname SPROCKET oname PRODUCTS type TABLE drop_objects TRUE END The procedure and do not support every type of object. For example you cannot use these procedures to drop and create constraints. Enter DBMS_REPCAT s EXECUTE_DDL procedure. The EXECUTE_DDL procedure allows you to perform DDL at multiple sites. The specification follows PROCEDURE DBMS DDL gname IN VARCHAR2 master_list IN VARCHAR2 NULL master_table IN ddl_text IN VARCHAR2 sname IN VARCHAR2 Parameters are summarized in the following table. Name Description gname Name of the replicated object group. master_list Comma-separated string of master site global names at which DDL is to be performed. If NULL the default DDL is applied at all master sites in the replication group. Use either parameter master_list or master_table. master_table PL SQL table of master site global names at which DDL is to be performed. Use either parameter master_list or master_table. ddl_text DDL statement to apply. Replicated Objects with DBMS_REPCAT 661 Appendix A What s on the Companion Disk sname Not used. Exceptions The EXECUTE_DDL procedure may raise the .