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 add one more column to existing index

803439May 30 2012 — edited May 30 2012
CREATE TABLE sk_abc_123 
  ( 
     a NUMBER, 
     b NUMBER 
  ); 

INSERT INTO sk_abc_123 
VALUES      (1, 2); 

INSERT INTO sk_abc_123 
VALUES      (10, 20); 


CREATE INDEX sk_abc_123_id1 ON sk_abc_123(a); 

now I want to have index on (a,b) columns combinedly as per my requirement, the one possible way is 

DROP INDEX sk_abc_123_id1;
CREATE INDEX sk_abc_123_id1 ON sk_abc_123(a,b); 

Can't we do it with out dropping an index? Meaning can't we alter an index to add a new column to the existing index?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2012
Added on May 30 2012
4 comments
37,831 views