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_NAME	INDEX_TYPE	TABLESPACE_NAME
PK_BRAND_ID	NORMAL	SYSTEM
PHONE_UNIQUE_IDX	NORMAL	SYSTEM

↑