You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for conflict resolution


1 to 20 of 784 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Best Practices for Apply

Configure Conflict Resolutionthat 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

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

About DML Conflicts in an Oracle Streams Environmentcan 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

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

Conflicts and Transaction Ordering in an Oracle Streams Environmentthis 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

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

3 Oracle Streams Conflict ResolutionStreams 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

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

Foreign Key Conflicts in an Oracle Streams EnvironmentA 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

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

Control Over Conflict Detection for Nonkey ColumnsBy 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

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

Avoid Specific Types of ConflictsIf 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

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

Conflict Types in an Oracle Streams EnvironmentYou 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

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

Uniqueness Conflicts in an Oracle Streams EnvironmentA 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.

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

Delete Conflicts in an Oracle Streams EnvironmentA delete conflict occurs when two transactions originate at different databases, with one

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

Update Conflicts in an Oracle Streams EnvironmentAn update conflict occurs when the apply process applies a row LCR containing an update to a row

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

Conflict Avoidance in an Oracle Streams EnvironmentThis 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

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

Custom Conflict Handlersthere 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

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

Rows Identification During Conflict Detection in an Oracle Streams EnvironmentTo 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.

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

Conflict Detection in an Oracle Streams Environmentprocess 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.

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Oracle Streams Conflict Resolution

Conflict Resolution in an Oracle Streams EnvironmentAfter 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

Streams Replication Administrator's Guide, 11g Release 1 (11.1)

Managing Capture, Propagation, and Apply

Managing Oracle Streams Conflict Detection and Resolutionfor 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

XML DB Developer's Guide, 11g Release 1 (11.1)

Using XLink and XInclude With Oracle XML DB

Configuring Conflict-Resolution for XInclude: ConflictRule ElementYou 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

Database Advanced Replication, 11g Release 1 (11.1)

Conflict Resolution Concepts and Architecture

Conflict Resolutionall 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

Streams Concepts and Administration, 11g Release 1 (11.1)

Glossary

conflict resolutionSee 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.