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