Re: Migrating 9i to 10g performance issues
Date: Tue, 25 Mar 2008 13:28:52 +0000
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-lReceived on Tue Mar 25 2008 - 08:28:52 CDT