How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Configure Conflict Resolution → that you configure conflict resolution for that object. To simplify conflict resolution for tables … parameter to TRUE. If you configure conflict resolution at a destination database, then additional … column list for conflict resolution during apply
Conflict Types in an Oracle Streams Environment → You can encounter these types of conflicts when you share data at multiple databases: Update Conflicts in an Oracle Streams Environment Uniqueness Conflicts in an Oracle Streams Environment Delete Conflicts in an Oracle Streams Environment Foreign Key Conflicts in an Oracle Streams Environment
Update Conflicts in an Oracle Streams Environment → An update conflict occurs when the apply process applies a row LCR containing an update to a row
Uniqueness Conflicts in an Oracle Streams Environment → A uniqueness conflict occurs when the apply process applies a row LCR containing a change to a row … inserting a row into a table with the same primary key value. In this case, the transactions cause a uniqueness conflict.
Foreign Key Conflicts in an Oracle Streams Environment → A foreign key conflict occurs when the apply process applies a row LCR containing a change to a row … originated at database A, then a foreign key conflict results because the row for the department with a
Conflict Detection in an Oracle Streams Environment → process detects an update conflict if there is any difference between the old values for a row in a … detects a uniqueness conflict if a uniqueness constraint violation occurs when applying an LCR that … contains an insert or update operation. An apply process detects a delete conflict if it cannot find a row … row does not exist.
Rows Identification During Conflict Detection in an Oracle Streams Environment → To detect conflicts accurately, Oracle must be able to identify and match corresponding rows at different databases uniquely. By default, Oracle uses the primary key of a table to identify rows in a table uniquely. When a table does not have a primary key, you should designate a substitute key. A substitute key is a column or set of columns that Oracle can use to identify uniquely rows in the table.
Conflict Resolution in an Oracle Streams Environment → After an update conflict has been detected, a conflict handler can attempt to resolve it. Oracle … Streams provides prebuilt conflict handlers to resolve update conflicts, but not uniqueness, delete … , foreign key, or ordering conflicts. However, you can build your own custom conflict handler to … resolve data
Custom Conflict Handlers → there is an update conflict. The resolution column is the column used to identify an update … conflict handler. If you use a MAXIMUM or MINIMUM prebuilt update conflict handler, then the resolution … column is also the column used to resolve the conflict. The resolution
3 Oracle Streams Conflict Resolution → Streams Environment Conflict Avoidance in an Oracle Streams Environment Conflict Resolution in an Oracle … Streams Environment See Also: \"Managing Oracle Streams Conflict Detection and Resolution\" … Some Oracle Streams environments must use conflict handlers to resolve possible data
Control Over Conflict Detection for Nonkey Columns → By default, an apply process compares old values for all columns during conflict detection, but you … can stop conflict detection for nonkey columns using the COMPARE_OLD_VALUES procedure in the … DBMS_APPLY_ADM package. Conflict detection might not be needed for some nonkey columns. See Also … : \"Stopping Conflict
Conflict Avoidance in an Oracle Streams Environment → This section describes ways to avoid data conflicts. Use a Primary Database Ownership Model You can avoid the possibility of conflicts by limiting the number of databases in the system that have simultaneous update access to the tables containing shared data. Primary ownership prevents all conflicts, because only a single database permits updates to a set of shared data. Applications can even use
Conflicts and Transaction Ordering in an Oracle Streams Environment → this case, a conflict occurs because a column value for the row at mult3.example.com does not match … a data conflict, transactions that are applied out of order might experience referential integrity … not exist at the remote database. If an ordering conflict is encountered, then you can resolve the … conflict
About DML Conflicts in an Oracle Streams Environment → can configure conflict resolution to resolve conflicts automatically, if your system design permits … A conflict is a mismatch between the old values in an LCR and the expected data in a table … originating at different databases update the same row at nearly the same time, a conflict can occur … possibility of
Delete Conflicts in an Oracle Streams Environment → A delete conflict occurs when two transactions originate at different databases, with one
Avoid Specific Types of Conflicts → If a primary database ownership model is too restrictive for your application requirements, then you can use a shared ownership data model, which means that conflicts might be possible. Even so, typically you can use some simple strategies to avoid specific types of conflicts. Avoid Uniqueness Conflicts in an Oracle Streams Environment You can avoid uniqueness conflicts by ensuring that each database
Managing Oracle Streams Conflict Detection and Resolution → for Nonkey Columns See Also: Chapter 3, \"Oracle Streams Conflict Resolution\" \"Displaying … the following prebuilt methods when you create an update conflict resolution handler: OVERWRITE … environment that illustrates using the MAXIMUM prebuilt method for time-based conflict resolution
Configuring Conflict-Resolution for XInclude: ConflictRule Element → You use the ConflictRule element of a resource configuration file to specify the conflict … -resolution rules to use if the path computed for a component document is already present in Oracle XML DB
Conflict Resolution → all sites. Oracle provides several prebuilt conflict resolution methods to resolve update conflicts … . Oracle also offers several conflict resolution methods to handle uniqueness conflicts, though these … methods cannot guarantee data convergence. Oracle does not provide any prebuilt conflict resolution
Conflict Resolution → , \"Conflict Resolution Concepts and Architecture\", for more information about avoiding conflicts … and for information about the conflict resolution methods available to you if conflicts can occur … environment, then you need a mechanism to ensure that the conflict is resolved in accordance with
conflict resolution → See Also: logical change record (LCR) conflict resolution Handling a conflict to avoid an apply … error. Either prebuilt update conflict handlers or custom conflict handlers can resolve conflicts.
Conflict Resolution Concepts → it is logged at the remote location and, optionally, a conflict resolution method is invoked. When a … purge job, which runs at a user-defined interval. See Also: Chapter 5, \"Conflict Resolution Concepts … hardware. Conflict Resolution Concepts When Oracle replicates a table, any DML
Conflict Resolution Concepts → Replication Conflicts Data Conflicts and Transaction Ordering Conflict Detection Conflict Resolution Techniques for Avoiding Conflicts … update the same row at nearly the same time, a conflict can occur. When you configure a replication … replication conflicts and a conflict occurs, then the system data
Conflict Resolution Architecture → Very few architectural mechanisms and processes are visible when implementing conflict resolution … conflict resolution and describes different aspects of Oracle's prebuilt conflict resolution methods … . This section contains these topics: Support Mechanisms Common Update Conflict
Delete Conflict Resolution Methods → data accuracy can be verified. Delete Conflict Resolution Methods Oracle does not provide any prebuilt … conflicts Oracle Database Advanced Replication Management API Reference to learn how to build conflict avoidance into your replication environment
6 Configuring Conflict Resolution → This chapter illustrates how to define conflict resolution methods for your replication environment … . This chapter contains these topics: Preparing for Conflict Resolution Creating Conflict Resolution … Methods for Update Conflicts Creating Conflict Resolution
Timestamp Conflict Resolution Methods → elements are needed to make time stamp conflict resolution work well: Synchronized time settings … steps to create a time stamp conflict resolution method. Note: If you are viewing this document … resolution method. Before defining time stamp conflict resolution methods,
Collecting Conflict Resolution Statistics → successful resolution of update, delete, and uniqueness conflicts for a table. The following example
Preparing for Conflict Resolution → converges correctly at all sites. Advanced Replication lets you define a conflict resolution system for … situation that Oracle's prebuilt conflict resolution methods cannot resolve, then you have the option … of building and using your own conflict resolution methods. Before you begin
Viewing Conflict Resolution Information → … ALL_REPRESOLUTION Shows more specific information about the conflict resolution method used to resolve conflicts … on each object. ALL_REPPARAMETER_COLUMN Shows which columns are used by the conflict resolution … Oracle provides replication catalog (REPCAT) views that you can use to determine what conflict
Auditing Successful Conflict Resolution → resolution statistics gathering for the table involved in the conflict. See Also: The ALL_REPRESOLUTION_STATISTICS view for more information … Whenever Oracle detects and successfully resolves an update, delete, or uniqueness conflict, you … can view information about what method was used to resolve the conflict by querying
Conflict Resolution Method Parameters → The parameters needed by a user-defined conflict resolution method are determined by the type of … . All conflict resolution methods take some combination of old, new, and current column values for … compare. The conflict resolution function should accept as parameters the values for
Conflict Resolution Mechanisms → Oracle provides a mechanism that enables you to define a conflict resolution method that resolves a data … conflict when detected. Oracle provides several prebuilt conflict resolution methods: Latest and … Group Site Priority If the prebuilt Oracle conflict resolution
Viewing Conflict Resolution Statistics → After calling REGISTER_STATISTICS for a table, each conflict that is successfully resolved for that
Minimum and Maximum Conflict Resolution Methods → maximum value conflict resolution methods, it compares the new value from the originating site with … designate this column when you define your conflict resolution method. If the new value of the … following steps to create an maximum or minimum conflict resolution method. Note: If
Clearing Statistics Information → Canceling Conflict Resolution Statistics Use the CANCEL_STATISTICS procedure in the DBMS_REPCAT … package if you no longer want to collect information about the successful resolution of update, delete … successful resolution of update, delete, and uniqueness conflicts, then you can remove this
Creating Conflict Resolution Methods for Uniqueness Conflicts → row, then you can define a resolution method with Oracle ' s prebuilt conflict resolution methods … . Oracle's prebuilt uniqueness conflict resolution method can make the conflicting value unique by … uniqueness conflict resolution method is a notification facility.
Obtaining Ownership → After locating the owner of the row, the acct_ny site gets ownership from the acct_sf site by completing the following steps: Lock the row at the sf site to prevent any changes from occurring while ownership is being exchanged. This operation ensures that only one site considers itself to be the owner at all times. The update at the sf site should not be replicated using DBMS_REPUTIL.REPLICATION_OFF.
Creating Conflict Resolution Methods for Update Conflicts → Oracle conflict resolution methods to deal with update conflicts that can occur when the same row receives two or more updates. … The most common data conflict occurs when the same row at two or more different sites are updated
Overwrite and Discard Conflict Resolution Methods → following steps to create an overwrite or discard conflict resolution method. This example illustrates the … use of the discard conflict resolution method at the master site. Therefore, in the event of a … you want to apply the conflict resolution method. Before you define overwrite
Creating Conflict Avoidance Methods for Delete Conflicts → update conflict resolution methods described in the previous section ineffective because only one value … contains the table to which you want to apply the conflict resolution method. */ BEGIN … conflict by marking a row for deletion and periodically purging the table of all marked records … conflict
Using Dynamic Ownership Conflict Avoidance → This section describes a more advanced method of designing your applications to avoid conflicts. This method, known as token passing, is similar to the workflow method described in the following sections. Although this section describes how to use this method to control the ownership of an entire row, you can use a modified form of this method to control ownership of the individual column groups within
Token Passing → Token passing uses a more generalized approach to meeting these criteria. To implement token passing, instead of the \"identifier\" columns, your replicated tables must have owner and epoch columns. The owner column stores the global database name of the site currently believed to own the row. Once you have designed a token passing mechanism, you can use it to implement a variety of forms of dynamic
Applying the Change → You should design your application to implement this method of token passing for you automatically whenever you perform an update. You should not allow the owner or epoch columns to be updated outside this application. The lock that you grab when you change ownership is released when you apply your actual update. The changed information, along with the updated owner and epoch information, are asynchronously
Workflow → conflicts can be resolved using a form of the priority conflict resolution method, where the … priority value increases with each step in the work flow process. The priority conflict resolution method
Locating the Owner of a Row → To obtain ownership, the acct_ny database uses a simple recursive algorithm to locate the owner of the row. The sample code for this algorithm is shown as follows: -- Sample code for locating the token owner. -- This is for a table TABLE_NAME with primary key PK. -- Initial call should initialize loc_epoch to 0 and loc_owner -- to the local global name. get_owner(PK IN primary_key_type, loc_epoch
Additive and Average Conflict Resolution Methods → … Instead of \"accepting\" one value over another, this conflict resolution method either adds the … steps to create an additive or average conflict resolution method. This example averages the … resolution method. Before you define additive and average conflict resolution
Priority Groups Conflict Resolution Methods → create a priority groups conflict resolution method. Note: If you are viewing this document online … resolution method. Before you define a priority groups conflict resolution method, quiesce the master … group that contains the table to which you want to apply the conflict resolution
Site Priority Conflict Resolution Methods → … example.com is used. Complete the following steps to create a site priority conflict resolution method … table to which you want to apply the conflict resolution method. Before you define a site priority … conflict resolution method, quiesce the master group that contains the
User-Defined Conflict Resolution Methods → Oracle enables you to write your own conflict resolution or notification methods. A user-defined … conflict resolution method is a PL/SQL function that returns either TRUE or FALSE. TRUE indicates that … available conflict resolution methods, in sequence order, until either a method
About Conflicts and Conflict Resolution → manually. To avoid apply errors, you must configure conflict resolution so that apply processes handle … that provide conflict resolution when a conflict results from an UPDATE on a row. These handlers … Conflict Resolution for a Table\" for instructions about configuring
Common Update Conflict Resolution Methods → Although Oracle provides eight prebuilt update conflict resolution methods, the latest time stamp … and the overwrite conflict resolution methods are the most commonly implemented resolution methods … guarantee data convergence. The latest time stamp and the overwrite conflict resolution
Creating a Conflict Notification Package → resolution. If possible, you should always use one of Oracle's prebuilt conflict resolution methods to … notification, assign the user-defined method to a column group (or constraint) along with conflict resolution … report_conflict; -- This is the conflict resolution
Techniques for Avoiding Conflicts → apply any conflict resolution methods to the column groups. When your replicated table contains … did not exist, then all of the columns in the table would be in the same column group, and a conflict … instead of column b2, then a conflict would have resulted, because both a1 and a3 are in the a_cg … procedural
Additional Update Conflicts Resolution Methods → If the latest time stamp or the overwrite conflict resolution methods do not meet your needs to … additional prebuilt update conflict resolution methods. Table 5-3 Convergence Properties of Additional … Update Conflict Resolution Methods Resolution Methods Convergence
B User-Defined Conflict Resolution Methods → This appendix describes how to build user-defined conflict resolution methods and user-defined … conflict notification methods. This appendix contains these topics: User-Defined Conflict Resolution … Methods User-Defined Conflict Notification Methods Viewing Conflict
Resolving Uniqueness Conflicts → column in the column group. The final parameter to the conflict resolution method should be a Boolean … conflict resolution method cannot guarantee convergence for uniqueness conflicts, a user-defined … Uniqueness conflicts can occur as the result of an INSERT or UPDATE. Your uniqueness conflict
Restrictions for User-Defined Conflict Resolution Methods → The following sections describe restrictions for user-defined conflict resolution methods. SQL … Statement Restrictions for User-Defined Conflict Resolution Methods Avoid the following types of SQL … statements in user-defined conflict resolution methods. Use of such statements can result
discard uniqueness → conflict. The append sequence method appends a generated sequence number to the column value. The column … length, then the conflict method does not resolve the error. Discard The discard uniqueness conflict … resolution method resolves uniqueness conflicts by simply discarding the row from the originating site
Understanding Your Data and Application Requirements → replicated data remains intact. Examples of Conflict Detection and Resolution To better understand how … where conflict detection and resolution is feasible in some cases but not possible in others: Conflict … because there is no way to resolve such a conflict. Conflict