- Printed in the U.S.A. - Reverse engineering of the software is prohibited.. - Overview of The Oracle8 Replication Manual. - Knowledge Assumed of the Reader. - Text of the Manual. - 1-2 Advanced Replication. - 5 Conflict Resolution. - 5-5 Conflict Resolution. - 5-6 Conflict Resolution Methods. - 5-14 Managing a Group’s Update Conflict Resolution Methods. - 6-2 Relocating a Master Group’s Definition Site. - 6-3 Changing a Snapshot Group’s Master Site. - Overview of The Oracle8 Replication Manual.. - Conflict resolution.. - Advanced Replication. - Note: In all cases, the defining query of the snapshot must reference all of the primary key columns in the master table.. - The view takes the name of the snapshot and provides read-only access to the snapshot.. - Reorganize the master tables of a snapshot without completing a full refresh of the snapshot.. - A snapshot site supports simple read-only and updatable snapshots of the table data at an associated master site. - Purging of the Deferred Transaction Queue. - Conflict Resolution. - This capability depends directly on the database link that the snapshot’s defining query uses to access the master table of the snapshot. - The defining query of the snapshot must reference all columns in the master table’s primary key.. - New rows exist that satisfy the selection criteria of the snapshot.. - In the following examples, the name of the central company database is hq.acme.com. - On the General page of the Create Refresh Group property sheet, specify the new group’s name, schema, refresh settings, and associated rollback segment.. - On the Snapshots page of the Create Refresh Group property sheet, specify a list of member snapshots for the new group. - A refresh group’s refresh interval determines the automatic refresh interval for all snapshots in the group. - The following examples are typical date expressions you can use for a refresh group’s refresh interval.. - When you create a refresh group, be sure to target a sufficiently large rollback segment for the group’s refreshes.. - Required Privileges Only the owner of the master table or a user with the SELECT privilege for the master table can alter a snapshot log.. - A network failure has prevented an automatic refresh of one or more of the snapshots based on the master table.. - Reorganization Notification When you reorganize a table, any ROWID information of the snapshot log must be invalidated. - The inputs are the owner and name of the master table to be reorganized. - For example, you might decide to drop a snapshot log if one of the following situations is true:. - registration during a subsequent refresh of the snapshot. - When you drop the only snapshot of a master table, you should also drop the snapshot log of the master table, if present.. - However, Oracle cannot perform a fast refresh of the snapshot until after you create a snapshot log for the new master table. - The wizard schedules purging of the deferred transaction queue for all master sites in the system.. - The next page of the wizard lets you create a list of the master sites in the new multimaster replication system. - The next page of the setup wizard lets you indicate default propagation characteristics for all master sites in the system. - The next page of the setup wizard lets you configure the default purge schedule for the deferred transaction queue at each master site in the system. - The next page of the setup wizard lets you customize settings for individual master sites in the system. - configuration of the multimaster advanced replication system. - Return to the final page of the wizard when you are ready to build the environment.. - See “Adding Objects to a Master Group” on page 3-19 for more information about creating and managing replicated objects.. - See “Resuming Replication Activity for a Master Group” on page 3-19 for more information about. - For example, you can configure continuous pushing and purging of the transaction queue. - You can change a group’s master definition site later, if necessary.. - See “Adding Objects to a Master Group” on page 3-19 for more information about adding replication objects to a master group.. - See “Adding a Master Site to a Master Group” on page 3-24 for more information about adding master sites to a replication group.. - Click the target master group in the database connection the connects to the group’s master definition site.. - Click the Operations page of the Edit Master Group property sheet.. - “quiescing” the group. - Click the target master group in the database connection that connects to the group’s master definition site.. - Click the General page of the Edit Replication Object property sheet.. - To specify new master sites, use the New button of the same page.. - Click the Destinations page of the Edit Master Group property sheet.. - Click the Destination Map folder of the target master group.. - The master definition and master sites of the master group.. - Click the Generated Objects folder of the target master group.. - Additional Information: See “Using Connection Qualifiers for a Master Group” on page 3-16.. - This example demonstrates how to create updatable snapshots of the master tables SCOTT.EMP and SCOTT.DEPT at the master site DBS1.. - Configure the default scheduling of data propagation from the snapshot site to its master site and purging of the deferred transaction queue.. - EMPLOYEE master group of the master site DBS1. - The next page of the wizard asks you to identify the master site for the new snapshot site(s) that you will be creating.. - Type the name of the master site (for example, DBS1).. - The next page of the wizard lets you create a list of the snapshot sites in the replication system. - The next page of the setup wizard lets you configure the default purge schedule for the deferred transaction queue at each snapshot site in the system. - The next page of the setup wizard lets you customize settings for individual snapshot sites in the system. - The next page of the setup wizard asks if you are ready to complete the configuration of the snapshot sites for the advanced replication system. - The following sections explain more about the settings that each page of the snapshot group wizard lets you indicate.. - Finally, you must select which objects in the master group to replicate as part of the new snapshot group. - Individual Snapshot Settings After selecting a snapshot from the Snapshots in the group list, you can adjust many of the snapshot’s properties.. - Use the General page to edit the target snapshot group’s master site and propagation mode to the master site.. - Note: When you drop a snapshot group, you can also decide whether to drop the group’s objects from the database. - If you choose not to drop a group’s objects when you drop the group, the objects remain in the database at the snapshot site.. - See “Creating a Snapshot Group” on page 4-12 for information on settings for the snapshot group wizard.. - Click the snapshot in the Snapshots in the group list of the Individual. - Snapshot Settings page of the snapshot group wizard.. - To create a subquery snapshot when using the snapshot wizard, type the subquery for the new snapshot in the Where Clause page of the snapshot wizard.. - Use the Scheduling page to configure the refresh group’s refresh settings.. - To edit a snapshot group’s refresh settings:. - Click the Scheduling page of the Edit Refresh Group property sheet.. - Click the General page of the Edit Refresh Group property sheet.. - At the Master Site:. - Conflict Resolution Methods. - Click the Conflict Resolution page of the Edit Replication Object dialog.. - Managing a Group’s Update Conflict Resolution Methods. - API Equivalent: DBMS_REPCAT.DROP_UPDATE_RESOLUTION Ordering a Column Group’s Update Conflict Resolution Methods. - There are no restrictions on the datatypes of the columns in the column group.. - The following example demonstrates an appropriate application of the latest timestamp update conflict resolution method:. - site–priority 1. - Define the name of the priority group and the datatype of the values in the group.. - These procedures are of the form. - Define the name of the site priority group.. - You must manage site priority groups from the master definition site of the corresponding master group.. - UNIQUE_RESOLUTION procedure of the DBMS_REPCAT package. - For example, the following statement assigns the APPEND_SEQUENCE uniqueness conflict resolution method to the C_CUST_NAME constraint of the CUSTOMERS table:. - To remove a uniqueness conflict resolution method from a constraint, use the DROP_ UNIQUE_RESOLUTION procedure of the DBMS_REPCAT package
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt