Free Web Hosting by Netfirms
 Web Hosting by Netfirms | Free Domain Names by Netfirms

AmZone

A m Z o n e

How to rename an index

How can an index be renamed? I used to follow the below path: 




   1. drop index am31_ind1; 
   2. create index am31_ind2 
          on am31(col5, col6) 
             storage... tablespace... 
             nologging;
As you can see, the index had to be dropped and recreated just to rename it. What in your opinion could be a much better process for renaming an index, or an additional step to be done with the above process to reduce downtime.


In previous versions of Oracle, the above said was the only alternative available. Starting Oracle 8i, renaming of index is allowed with a command!!! 




   alter index am31_ind1 rename to am31_ind2;

Press the Back button of you Browser to go to previous page
Home