Re: Reverse Index columns
You could always create a new table with your new indexes, load the data from the old table and swap them using rename table. It can be tricky to maintain consistency between the two tables, but you shouldn't have to deal with long locks while your application is trying to access data.
Subject
Written By
Posted
February 07, 2009 04:38AM
February 07, 2009 11:53PM
February 08, 2009 06:01AM
Re: Reverse Index columns
February 08, 2009 12:04PM
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.