Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqllder hangs at 99-100% CPU on select of fet$

Re: sqllder hangs at 99-100% CPU on select of fet$

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Wed, 24 Sep 2003 13:13:18 GMT
Message-ID: <3F71986E.9EDAFEAA@remove_spam.peasland.com>


Why not use mig to upgrade your database? This is manual, but will be much quicker (and easier) than emp/imp.

HTH,
Brian

Don Seiler wrote:
>
> On Tue, 23 Sep 2003 22:15:14 -0700, Daniel Morgan wrote:
>
> > Time estimates are impossible. Even approximations unlikely to be
> > accurate. Can't you get a copy of 8i and install
> > it just long enough to upgrade 7.3.4 to 8i and then 8i to 9i all in
> > place. That way you won't have to perform any
> > exports or imports. And I, for one, wouldn't want to move 286GB unless I
> > had to.
>
> Not sure why I would do the 8i step when I can migrate directly from 7.3.4
> to 9i in place. I was just considering exp/imp as a way to also clean up
> the physical structure of the database.
>
> I'll see if I can get the sys admin to give me a slice of disk and export
> the test database which I just loaded from a production hot backup.

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Wed Sep 24 2003 - 08:13:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US