Re: Migrating 9i to 10g performance issues
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-lReceived on Tue Mar 25 2008 - 08:23:53 CDT