Indexs after table name changed
Posted by: Martin Ng
Date: June 24, 2016 04:42PM

I have a table (say, BigTable) with four already created indexs. After I've rename the BigTable to BigTableB, I found out those indexes are no longer valid in the BigTableB, and I need to recreate those indexes using the new table name which is BigTableB. This could cause a lot down time. I wonder if there is a way I could accomplish altering the name of a table and have those existing indexes go with the new table name without recreating them.
Thank you.

Options: ReplyQuote

Written By
Indexs after table name changed
June 24, 2016 04:42PM

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.