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;Best viewed in medium text size. Please refresh this page (F5) to view the latest information.
This page was created on 15-dec-2000 and last updated on 15-dec-2000.
please forward all queries to amar_padhi@fastmail.fm