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
Delete Conflicts in an Oracle Streams Environment → A delete conflict occurs when two transactions originate at different databases, with one
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.
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
Custom Conflict Handlers → which you want to perform conflict resolution. Set the object_type parameter to TABLE. Set the … want an error handler to perform conflict resolution when an error is raised, then set the … error_handler parameter to TRUE. Or, if you want to include conflict resolution in your procedure
Stopping Conflict Detection for Nonkey Columns → DBMS_APPLY_ADM package. For example, suppose you configure a time column for conflict resolution for … for a detailed example that uses time-based conflict resolution Oracle Database PL/SQL Packages and … You can stop conflict detection for nonkey columns using the COMPARE_OLD_VALUES procedure in the
Modifying an Existing Update Conflict Handler → and resolution column as the existing conflict handler. To modify the update conflict handler created … as the resolution column. You can modify this update conflict handler by specifying a different type … You can modify an existing update conflict handler by running the SET_UPDATE_CONFLICT_HANDLER
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
Displaying Information About Conflict Detection → You can stop conflict detection for nonkey columns using the COMPARE_OLD_VALUES procedure in the … DBMS_APPLY_ADM package. When you use this procedure, conflict detection is stopped for updates and … column for which conflict detection has been stopped, run the following query: COLUMN OBJECT_OWNER … NO NO HR EMPLOYEES PHONE_NUMBER
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
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
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.
Setting an Update Conflict Handler → illustrates using the MAXIMUM prebuilt method for time-based conflict resolution Oracle Database SQL Language Reference for information about data types … Set an update conflict handler using the SET_UPDATE_CONFLICT_HANDLER procedure in the … DBMS_APPLY_ADM package. You can use one of the following prebuilt methods when you create an
Removing an Existing Update Conflict Handler → method, and specify the same table, column list, and resolution column as the existing conflict … You can remove an existing update conflict handler by running the SET_UPDATE_CONFLICT_HANDLER … procedure in the DBMS_APPLY_ADM package. To remove a an existing conflict handler, specify NULL for the … handler. For
9 Oracle Streams Conflict Resolution → Streams Environment Conflict Avoidance in an Oracle Streams Environment Conflict Resolution in an Oracle … Streams Environment Managing Oracle Streams Conflict Detection and Resolution Monitoring Conflict Detection and Update Conflict Handlers … Some Oracle Streams environments
Prebuilt Update Conflict Handlers → column lists and resolution columns are used in prebuilt update conflict handlers. A column list is a … 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
Monitoring Conflict Detection and Update Conflict Handlers → replication environment: Displaying Information About Conflict Detection Displaying Information About … Update Conflict Handlers See Also: Oracle Streams Concepts and Administration
Managing Oracle Streams Conflict Detection and Resolution → This section describes the following tasks: Setting an Update Conflict Handler Modifying an … Existing Update Conflict Handler Removing an Existing Update Conflict Handler Stopping Conflict Detection … for Nonkey Columns See Also: \"Displaying Information About Update Conflict Handlers\"
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
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.
Conflicts and Transaction Ordering in an Oracle Streams Environment → conflict results because the row for the department with a department_id of 271 does not yet exist … . In this case, a conflict occurs because a column value for the row at mult3.example.com does not … causing a data conflict, transactions that are applied out of order might experience referential … does not exist at the remote