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