Index rename Tips

Environment 11.2.0.3.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.

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.