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?
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.