Create Unique Explicit Index

Create Unique Explicit Index example

  

-- create Unique Explicit Index
CREATE UNIQUE INDEX phone_unique_idx
  ON PHONE_BRANDS(NAME)
      TABLESPACE SYSTEM
      STORAGE (INITIAL 10K
      NEXT 10k
      PCTINCREASE 75);  

Output:

unique index PHONE_UNIQUE_IDX created.

Check indexes

select INDEX_NAME, INDEX_TYPE, TABLESPACE_NAME
from USER_INDEXES
WHERE table_name='PHONE_BRANDS';  

Output:

INDEX_NAMEINDEX_TYPETABLESPACE_NAME
PK_BRAND_IDNORMALSYSTEM
PHONE_UNIQUE_IDXNORMALSYSTEM