Đang chuẩn bị liên kết để tải về tài liệu:
Oracle Built−in Packages- P135

Oracle Built−in Packages- P135: 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 The replication group must already exist and be quiesced. 15.3.3.3.3 Examples The following call removes table SPROCKET.PRODUCTS from the SPROCKET replication group but preserves the table BEGIN DBMS_REPCAT.DROP_MASTER_REPOBJECT 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 DBMS_REPCAT.DROP_MASTER_REPOBJECT sname SPROCKET oname PRODUCTS type TABLE drop_objects TRUE END 15.3.3.4 The DBMS_REPCAT.EXECUTE_DDL procedure DBMS_REPCAT.CREATE_MASTER_REPOBJECT and DBMS_REPCAT.DROP_MASTER_REPOBJECT 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 REPCAT.EXECUTE DDL gname IN VARCHAR2 master_list IN VARCHAR2 NULL master_table IN dbms_utility.dblink_array 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. 15.3.3 Replicated Objects with DBMS_REPCAT 661 Appendix A What s on the Companion Disk sname Not used. 15.3.3.4.1 Exceptions The EXECUTE_DDL procedure may raise the .