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
Unique Identifiers → Unique identifiers are specified for one distinct record in a dimension table. Artificial unique … identifiers are often used to avoid the potential problem of unique identifiers changing. Unique
Unique and Nonunique Indexes → Indexes can be unique or nonunique. Unique indexes guarantee that no two rows of a table have … column values. Oracle recommends that unique indexes be created explicitly, and not through enabling … a unique constraint on a table. Alternatively, you can define UNIQUE integrity constraints on the
Directories with Unique Formats → Some connected directories cannot receive data by using any of the interfaces supported by Oracle Internet Directory. The profiles for this type of directory contain an attribute identifying a separate program for synchronization. This program, called an agent, translates between the connected directory's specialized format and a tagged or LDIF file containing the synchronization data. The Oracle
WM_ERROR_10 unique key violation → Cause: An insert operation failed because it violated the table's primary key constraint. Action: Ensure that the primary key is not violated by the insert operation in the current workspace.
UNIQUE Key Integrity Constraints → A UNIQUE key integrity constraint requires that every value in a column or set of columns (key) be … unique--that is, no two rows of a table have duplicate values in a specified column or set of … columns. For example, in Figure 21-3 a UNIQUE key constraint is defined on the DNAME column of the … departments table to disallow
Unique Constraints and Indexes → A user sees inconsistent constraints, including duplicates in unique indexes, when that user's … transaction produces these inconsistencies. You can place deferred unique and foreign key constraints on … materialized views, allowing fast and complete refresh to complete successfully. Deferrable unique … constraint. Not-deferrable
SP2-0617 Cannot construct a unique STATEMENT_ID → Cause: Unable to construct a unique statement ID in AUTOTRACE. Action: Check that AUTOTRACE is configured and that you have the PLUSTRACE role enabled.
EPCW-01012: Event name is not unique. → Cause: The user tried to add an event with a non-unique event name; event name must be unique within a product. Action: Use a different event name.
EPCW-01001: Event number is not unique. → Cause: The user attempted to add or modify an event such that its event number is not unique within
When to Use UNIQUE Key Integrity Constraints → Choose columns for unique keys carefully. The purpose of these contraints is different from that of … primary keys. Unique key constraints are appropriate for any column where duplicate values are not … have no significance other than being unique. Note: Although UNIQUE key constraints allow values … , you cannot
PRIMARY KEY and UNIQUE KEY Constraints → PRIMARY KEY and UNIQUE KEY constraints create indexes on a table when they are enabled, and
UNIQUE Constraints in a Data Warehouse → A UNIQUE constraint is typically enforced using a UNIQUE index. However, in a data warehouse whose … tables can be extremely large, creating a unique index can be costly both in processing time and in … ensure that this column is unique within the data warehouse. One way to create the constraint is as … follows:
EPCW-01011: Item name is not unique. → Cause: The user tried to add an item with a non-unique item name; item name must be unique within a product. Action: Use a different item name.
EPCW-00040: Collection name must be unique. → Cause: A collection name must be unique. Action: Modify the collection name so that it is unique.
EPCW-01002: Item number is not unique. → Cause: The user attempted to add or modify an item such that its item number is not unique within the product. Action: Choose a different number.
EPCW-01013: Event Set name is not unique. → Cause: The user tried to add an event set with a non-unique name; event set name must be unique
Parameters That Must Be Unique Across All Instances → If you use the THREAD or ROLLBACK_SEGMENTS parameters, Oracle Corporation recommends setting unique … unique value for INSTANCE_NUMBER for each instance and you cannot use a default value. Oracle uses … undo management enabled, set this parameter to a unique value for each instance.
Setting a Column to a Unique Sequence Number → The SEQUENCE parameter ensures a unique value for a particular column. SEQUENCE increments for each
WM_ERROR_109 a table with unique constraints cannot be version enabled → Cause: An attempt was made to version-enable a table that had unique constraints defined on it … . Action: Drop the unique constraint on this table before version-enabling it. If the table needs to have … a index for performance reasons, create a non-unique index on the relevant set of columns. Oracle