Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to alter index

586651Sep 17 2008 — edited Sep 18 2008
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)
i want to alter index un1 on a1 to un1 (a1,a2,a3) on table xx_test

Thanks in Advance

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 16 2008
Added on Sep 17 2008
5 comments
426 views