Environment 220.127.116.11.0 RAC/ASM/RHEL64bit
We are trying to create index and there same name index exist in database already
so we decided to drop the old index and create the new index but dropping the old index takes times we already wait last 3 minutes so we cancel it.
We then tried to rename the old index as below…
and it’s perform quickly 🙂
then we create the new index with same name.