Index: changing the name
Posted by: Les Stockton
Date: December 27, 2005 03:32PM

Is there an easy way to change the name of an index, without having to drop it and create a new one?

I know how to find the index name in the information_schema.statistics table, but these seems more reflective. If I were to change the name here, that doesn't really change the name of the index, does it?
Is there a SQL statement to change the name of an index from one name to another?

If not a SQL statement, is there any other way to change the name of the index?

And if I can't change the name of the Index, is there a way to copy the index to a new one and then remove the old index? I figure this would still be faster than droppiing the index and creating a new one.

Edited 2 time(s). Last edit at 12/27/2005 04:15PM by Les Stockton.

Options: ReplyQuote

Written By
Index: changing the name
December 27, 2005 03:32PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.