Re: Migrating 9i to 10g performance issues

From: Howard Latham <howard.latham_at_gmail.com>
Date: Tue, 25 Mar 2008 13:23:53 +0000
Message-ID: <713d96d10803250623oc892628u2f499e22794d5509@mail.gmail.com>


You transport the whole lot then it doesnt matter about self containment. I will try and post my my script ! - pretty horrific !

On 25/03/2008, Sandra Becker <sbecker6925_at_gmail.com> wrote:
>
> I did a little more research on transportable tablespaces. Only two of my
> tablespaces are self-contained and they hold very little data so I don't
> think this is a viable option. Also the idea of upgrading then migrating
> has been nixed and will not be considered going forward for various reasons,
> none of which make sense to me at this point.
>
> Sandy
>
> On Tue, Mar 25, 2008 at 6:19 AM, Howard Latham <howard.latham_at_gmail.com>
> wrote:
>
> > For our 700gig database I used transportable tablespaces / datapump from
> > Windows nt to redhat.
> > Worked well once I got the strategy right.
> > In my experience get a spare box for a few practices.
> >
> >
>

-- 
Howard A. Latham

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 25 2008 - 08:23:53 CDT

Original text of this message