tailieunhanh - Oracle Built−in Packages- P141

Oracle Built−in Packages- P141: 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 NOTE If you change the propagation mode you must also regenerate the replication support triggers for all replicated tables ALTER_MASTER_PROPAGATION does not do this automatically. After altering the propagation method you must call for all replicated tables in the replication group. The procedure Oracle8 only The default behavior of advanced replication is to send the old and new values of every column to participating master sites whenever you update a row in a replicated table. At the destination sites Oracle uses this information to ensure that the version of the row that you updated matches the version of the row currently at the destination. However if you know that certain columns in a table will never change you can avoid sending the data in these columns when you propagate updates to participating master sites. Using the SEND_AND_COMPARE_OLD_VALUES procedure available only in Oracle8 in this way you ll reduce propagation overhead. Here is the specification PROCEDURE sname IN VARCHAR2 oname IN VARCHAR2 column_list IN VARCHAR2 column_table IN operation IN VARCHAR2 UPDATE send IN BOOLEAN TRUE Parameters are summarized in the following table. Name Description sname Name of the replication group whose propagation mode is being altered oname Table being altered column_list Comma-separated list of columns whose propagation mode is being altered indicates all nonkey columns column_table PL SQL table of containing columns whose propagation is being altered operation Operation for which this change applies this may be UPDATE DELETE or indicating both updates and deletes send If TRUE the default then the old values for the columns are sent if FALSE then old values are not sent NOTE The configuration changes you specify with this procedure do not take effect unless the .