File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Alter Unique Index

 
Jane Somerfield
Ranch Hand
Posts: 193
  • 0
  • 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: 33696
316
Eclipse IDE Java VI Editor
  • 0
  • 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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic