Re: Migrating 9i to 10g performance issues
- From: "Howard Latham" <howard.latham@xxxxxxxxx>
- To: "Sandra Becker" <sbecker6925@xxxxxxxxx>
- Date: Tue, 25 Mar 2008 13:28:52 +0000
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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx>
> > 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
Other related posts:
