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: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 23 Sep 2003 22:59:02 -0700
Message-ID: <1064383135.397959@yasure>


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.
>
>

You are correct. You can do it directly. That is definitely the best way to do it. If you have something to clean up ... clean it up in place.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Sep 24 2003 - 00:59:02 CDT

Original text of this message

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