Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Alter Unique Index

 
Jane Somerfield
Ranch Hand
Posts: 193
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a table created in following way:

create table TAB1 (
ID number not null,
VAL1_NBR varchar2(30) not null,
VAL2_NBR varchar2(5) not null,
VAL3_CD varchar2(2),
VAL4_NBR varchar2(30) not null,
VAL5_IND char(1),
constraint TAB1_PK primary key (ID)
);

create unique index TAB1_IDX1 on TAB1 (
VAL1_NBR ASC,
VAL2_NBR ASC,
VAL3 CD ASC
);

Now I need to change the unique index to add one more value
"VAL4_NBR". How do I use alter command to do it?

Thanks
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jane,
You can use the "alter index" command. However, I would recommend dropping the existing index and creating a new one. The database needs to rebuild the index either way. And using "create index" gives you the command if you need to build the index in the future.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic