J
James Palmer
Guest
As a way of explaining, it's a 150GB area made up of extents that are smaller than 2GB. Most a lot smaller. It's a really bad structure. I'm moving stuff around to more sensible areas. On that note, the bit that is taking the time is the index rebuild at the end. My process is as follows. Does anyone have any tips on something I could do differently (OE11.2.1)? Binary Dump Data Drop tables Add new areas Create df and move stuff to the new areas needed Remove the now surplus storage area Load the binaries Rebuild indexes Everything is scripted and works beautifully, it's just the index rebuild that is taking forever.
Continue reading...
Continue reading...