Re: Migrating 9i to 10g performance issues

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


expdp %USERNAME%/easyeasy
dumpfile=expdatlive.dnptransport_tablespaces=(USERS,TOOLS,INDX,PVDF_REFDATA,OEM_REPOSITORY,QHRS91_IDX,COMMS2002_REFDATA,HHMASTER_DATA,COMMS,PVDF_DEMOGS_IDX,COIN_STUDY_INDEX,PVDF_IDX,COMMS91_REFDATA,COMMS91,QC_VIEWING_IDX,COMMS2000,COMMS_IDX,QHRS2002,ESTAB_DATA,COMMS2001,ESTAB_IDX,PVDF_WORK_DATA,QC_INDEX,QHRS91_DATA,COMMS91_IDX,PM_CONTACTS_INDEX,HHMASTER_IDX,QC_VIEWING_DATA,PVDF_REFDATA_IDX,PVDF,QHRS91_REFDATA_IDX,QHRS91_REFDATA, PM_CONTACTS_DATA, UNDOTBS, SMALL_TABLES, COMMS2002, COMMS2003, PVDF_VIEW_IDX, PROGS2002,PROGS_IDX,PVDF_VIEWING_DATA, COMMS2004, QC_REPORTS_DATA, COMMS_IDX_2002, COIN_STUDY_DATA, PVDF_WEIGHTS_DATA, PVDF_WEIGHTS_INDEX, PVDF_WORK_INDEX,COMMS2005) transport_full_check=Y directory=my_dir logfile=my_dir_log
rem copy h:\oradata\live\*.* V:\H\

Then copy all the data files

Once you have done this you use rman to do the convert the datafiles

On 25/03/2008, Howard Latham <howard.latham_at_gmail.com> wrote:
>
> 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
>

-- 
Howard A. Latham

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

Original text of this message