Niall Litchfield wrote:
> "Don Seiler" <don_at_seiler.us> wrote in message
> news:pan.2003.09.24.05.16.59.15543_at_seiler.us...
>
>>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.
>
>
> 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).
>
>
Also, if you feel compelled to use exp/imp, look at using this
http://sourceforge.net/projects/pepi/. I have used this in the past and
had very good results.
--
Ron Reidy
Oracle DBA
Received on Wed Sep 24 2003 - 06:11:54 CDT
