TAILIEUCHUNG - Oracle Built−in Packages- P144

Oracle Built−in Packages- P144: 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 DBMS_RECTIFIER_DIFF book index 16. Conflict Resolution Comparing Replicated Tables . Orode PL SQL Orode PL SQL Orode Advonced PL SQL Orode Wei Applications Grade PL SQL Grade PL SQL rar Programming I Programming I Buitin I Programming I PL SQL Developer s I Language I Bait-ins MW Second Edition Guide to Orodeii Features Packages wrrti Packages Introduction Pocket Reference Pocket Reference Copyright c 2000 O Reilly Associates. All rights reserved. 706 Oracle Built-in Packages SEARCH PREVIOUS Chapter 16 NEXT 707 16. Conflict Resolution Contents Getting Started with DBMS_REPCAT Column Groups with DBMS_REPCAT Priority Groups with DBMS_REPCAT Site Priority Groups with DBMS_REPCAT Assigning Resolution Methods with DBMS_REPCAT Monitoring Conflict Resolution with DBMS_REPCAT Conflict resolution is perhaps the most difficult challenge for the administrator of a replicated environment that uses asynchronous replication. A conflict can arise when an insert update or delete to a replicated table occurs at two or more master sites. Oracle detects conflicts at the destination site when attempting to apply the changes. Three different types of conflicts can arise Insert conflicts An inserted row has a primary key that already exists at the destination site. Update conflicts The pre-update data in a row at the originating site does not match the current data at the destination site. Delete conflicts A deleted row does not exist at the destination site. Through the DBMS_REPCAT package Oracle s advanced replication option gives you tools for identifying and resolving conflicts automatically. The goal is to ensure that data at all master sites converges -- that is all rows end up with identical data at all sites. WARNING The procedures described in this chapter are no substitute for careful application and schema design and they can t resolve all conflicts. Getting Started with DBMS_REPCAT Use the DBMS_REPCAT package to deal with .

• Cơ sở dữ liệu
• cơ sở dữ liệu MySQL
• database SQL
• thiết kế CSDL quan hệ
• Kiến trúc hệ quản trị CSDL
• đặc tính cơ sở dữ liệu
• bảo mật cơ sở dữ liệu
• Cơ sở dữ liệu
• Hệ quản trị cơ sở dữ liệu MySQL
• Quản trị cơ sở dữ liệu
• Làm việc với MySQL
• Giới thiệu về MySQL
• Bài giảng Phần mềm nguồn mở
• Phần mềm nguồn mở
• Hệ quản trị cơ sở dữ liệu
• Lịch sử phát triển MySQL
• Kiến trúc MySQL
• MySQL Command Line
• MySQL Query Browser
• giáo trình cơ sở dữ liệu
• lý thuyết cơ sở dữ liệu
• bái giảng cơ sở dữ liệu
• tài liệu cơ sở dữ liệu
• Kết nối với MySQL
• Truy xuất cơ sở dữ liệu
• Quản lý dữ liệu
• Kết nối cơ sở dữ liệu
• Cập nhật dữ liệu
• Kích hoạt dữ liệu
• cơ sở dữ liệu sql server
• MySQL cơ bản