File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Alter Unique Index Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Alter Unique Index" Watch "Alter Unique Index" New topic

Alter Unique Index

Jane Somerfield
Ranch Hand

Joined: Jul 20, 2002
Posts: 193
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 (

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

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32817

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.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Don't get me started about those stupid light bulbs.
subject: Alter Unique Index
It's not a secret anymore!