Oracle Designer Model, Release 6i
Uniqueness Criteria

USER_OBJECT_INDEX_STORAGE

Uniqueness may be enforced by database constraints and/or the API, depending on the complexity of the uniqueness criteria

• Database constraints are used when the uniqueness criteria can be expressed simply as a combination of columns. These are defined as unique key constraints placed on the underlying table.
• The API is used when the uniqueness criteria cannot be expressed simply as a combination of columns. These are defined in PL/SQL.

Uniqueness enforced by database constraints

The following unique key constraints exist for the underlying table SDD_INS

Unique Key Constraint	Column
UK_HANDCRAFTED_INS	( 2 ) CLUSTER_REF ( 4 ) TABLE_IMPLEMENTATION_REF ( 6 ) SNAPSHOT_REF ( 8 ) IMPLICIT_INDEX_TYPE ( 10 ) INDEX_REF ( 12 ) PRIMARY_KEY_REF ( 14 ) UNIQUE_KEY_REF

Uniqueness enforced in PL/SQL by the API

See API Spec for USER_OBJECT_INDEX_STORAGE