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 UNIQUE


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


SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

UNIQUE *UPDATE * USER *

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Logical Design in Data Warehouses

Unique IdentifiersUnique 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

Concepts, 9i Release 2 (9.2.0.2)

Schema Objects

Unique and Nonunique IndexesIndexes 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

Administrator's Guide, 9i Release 2 (9.2.0.2)

The Oracle Directory Synchronization Service

Directories with Unique FormatsSome 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

Application Developer's Guide - Workspace Manager, 9i Release 2 (9.2.0.2)

Error Messages

WM_ERROR_10 unique key violationCause: 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.

Concepts, 9i Release 2 (9.2.0.2)

Data Integrity

UNIQUE Key Integrity ConstraintsA 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

Concepts, 9i Release 2 (9.2.0.2)

Data Integrity

Unique Constraints and IndexesA 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

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0617 Cannot construct a unique STATEMENT_IDCause: Unable to construct a unique statement ID in AUTOTRACE. Action: Check that AUTOTRACE is configured and that you have the PLUSTRACE role enabled.

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Trace Messages

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.

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Trace Messages

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

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Maintaining Data Integrity Through Constraints

When to Use UNIQUE Key Integrity ConstraintsChoose 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

Utilities, 9i Release 2 (9.2.0.2)

Conventional and Direct Path Loads

PRIMARY KEY and UNIQUE KEY ConstraintsPRIMARY KEY and UNIQUE KEY constraints create indexes on a table when they are enabled, and

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Integrity Constraints

UNIQUE Constraints in a Data WarehouseA 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:

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Trace Messages

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.

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Trace Messages

EPCW-00040: Collection name must be unique.Cause: A collection name must be unique. Action: Modify the collection name so that it is unique.

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Trace Messages

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.

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Trace Messages

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

Administration, 9i Release 2 (9.2.0.2)

Parameter Management in Real Application Clusters Environments

Parameters That Must Be Unique Across All InstancesIf you use the THREAD or ROLLBACK_SEGMENTS parameters, Oracle Corporation recommends setting uniqueunique 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.

Utilities, 9i Release 2 (9.2.0.2)

Field List Reference

Setting a Column to a Unique Sequence NumberThe SEQUENCE parameter ensures a unique value for a particular column. SEQUENCE increments for each

Application Developer's Guide - Workspace Manager, 9i Release 2 (9.2.0.2)

Error Messages

WM_ERROR_109 a table with unique constraints cannot be version enabledCause: 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