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

Tubby
Drop index un1 ;
create index un1 on xx_test (a1,a2,a3) ;
586651
I dont want to drop the index is it possible to alter?
659537
yes you can alter index with "alter index" syntax to change.
You can alter index for :-
Rebuild or coalesce an existing index
Deallocate unused space or allocate a new extent
Specify parallel execution (or not) and alter the degree of parallelism
Alter storage parameters or physical attributes
Specify LOGGING or NOLOGGING
Enable or disable key compression
Mark the index unusable
Start or stop the monitoring of index usage

-----You cannot alter an index's column structure.---------

For more details check in the documentation
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/indexes.htm#518
659537
yes you can alter index with "alter index" syntax to change.
You can alter index for :-
Rebuild or coalesce an existing index
Deallocate unused space or allocate a new extent
Specify parallel execution (or not) and alter the degree of parallelism
Alter storage parameters or physical attributes
Specify LOGGING or NOLOGGING
Enable or disable key compression
Mark the index unusable
Start or stop the monitoring of index usage

-----You cannot alter an index's column structure.---------

For more details check in the documentation
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/indexes.htm#518
Karthick2003
[ALTER INDEX|http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_1008.htm#SQLRF00805] is beautifully documented.

Thanks,
Karthick.
1 - 5
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
425 views