Home » SQL & PL/SQL » SQL & PL/SQL » How to alter index
How to alter index [message #348707] Wed, 17 September 2008 13:48 Go to next message
Messages: 20
Registered: June 2007
Location: somerset
Junior Member

How to alter index example is
un1 -- index name
xx_test -- Table name
a1,a2,a3 are the column names of table xx_test

create unique index un1 on xx_test (a1)
can i know how can i alter index un1 on a1 to un1 (a1,a2,a3) on table xx_test

Thanks in Advance
Re: How to alter index [message #348709 is a reply to message #348707] Wed, 17 September 2008 14:22 Go to previous message
Michel Cadot
Messages: 65152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't. You have to recreate the index.

Previous Topic: Getting completed status of concurrent request
Next Topic: dbms_jobs
Goto Forum:

Current Time: Tue Aug 22 04:25:44 CDT 2017

Total time taken to generate the page: 0.01355 seconds