Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqllder hangs at 99-100% CPU on select of fet$
On Wed, 24 Sep 2003 11:48:11 +0100, Niall Litchfield wrote:
> In principle I think I'd prefer the exp/imp routine for the reasons you
> suggest. However 1/4 terabyte will take a very long time indeed. If you have
> the disk space another alternative is to do the in place upgrade - leaving
> the mess you have got in place and then once you are happy create a whole
> new set of tablespaces and move your objects across using dbms_redefinition
> which is a new 9i package for online operations (though there are
> restrictions).
Yes I suppose this will also work. Although next year I'll end up doing an exp/imp anyway unless there is better way to migrate from Oracle on HP-UX to Linux/Intel. I have done an upgrade in test using mig and it seemed to go alright.
But what Niall says does make sense. I forget that I can do all those great operations like "move" in 9i that I can't in 7.3.4!
Thanks Niall, Daniel, and Brian. Received on Wed Sep 24 2003 - 08:25:43 CDT