R
Richard Banville
Guest
Although not the fastest and it will take up lots of bi space, index move does allows managing your indexes in a replication environment. Can you further explain what you mean by not wanting to invalidate the upgrade due to a delta df? If you reorg prior to the conversion there will be no delta df due to this. Index rebuild is another approach if not running in a replication environment. It too is slow in 10.1c (the performance enhancements went into 102b) but faster than index move without the affect on the bi. How big is the database? It might be best to just dump and load as opposed to re-orging it in place.
Continue reading...
Continue reading...